Tools to keep database real time and inventory by IP address

Dear all,

right now we have a project to, by IP address of that database server, to show out inventory information and all run times process as well as their loading pattern, in order to:

1) e.g. if a fault is found on a particular system which involve a database,  it can help to list out all the details.
2) provide all information and detail for us to troubleshoot when a fault related to application which connects to a db is found.

Any this kind of tools for me to reference.

database need to be check is:
1) Oracle.
2) MySQL
3) MS SQL
4) DB2.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Alexander Eßer [Alex140181]Software DeveloperCommented:
Take a look at this tool:
http://www.zabbix.com/

https://www.zabbix.com/wiki/howto/monitor/db/orabbix_monitor_oracle_with_zabbix

Our sys admins work with this and they are really comfortable with the tool. Quite easy to deploy and to work with, apart from the low cost (if any)...
0
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
You should also look at SolarWinds tools as they do a very good job of monitoring and alerting.  Free options are Nagios, Zabbix, Zennos, etc.
0
marrowyungSenior Technical architecture (Data)Author Commented:
Mohammed Khawaja,

Solarwind don't monitor MySQL, please correct me if I am wrong.

Alexander Eßer,

this link seems showing me that Zabbix do not monitor MS SQL ? I don't see that in the list.

I even don't see it can monitor DB2 as well.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Alexander Eßer [Alex140181]Software DeveloperCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
can they install on Windows ?
0
marrowyungSenior Technical architecture (Data)Author Commented:
backend database can be  MS SQL ?
0
Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Not for Zabbix.
0
marrowyungSenior Technical architecture (Data)Author Commented:
Zabbix must installed on Linux and data host on MySQL ?
0
Alexander Eßer [Alex140181]Software DeveloperCommented:
Zabbix must installed on Linux and data host on MySQL ?

Considerung server and/or proxy, yes:
http://www.zabbix.com/requirements.php

What do you mean with "data host on MySQL" btw?!
0
marrowyungSenior Technical architecture (Data)Author Commented:
"What do you mean with "data host on MySQL" btw?! "

the zabbix install on linux and the data collected by Zabbix store on MySQL,

"Considerung server and/or proxy, yes:
http://www.zabbix.com/requirements.php"

so Windows only supported by Agent and Windows can only be monitored?
0
Alexander Eßer [Alex140181]Software DeveloperCommented:
so Windows only supported by Agent and Windows can only be monitored?
Yes. You may install Zabbix agent(s) software on Windows for monitoring purposes, but not as a Zabbix server or proxy.

Supported DBs from https://www.zabbix.com/documentation/2.2/manual/installation are:
MySQL
Oracle
PostgreSQL
SQLite
IBM DB2
0
marrowyungSenior Technical architecture (Data)Author Commented:
"Supported DBs from https://www.zabbix.com/documentation/2.2/manual/installation are:
 MySQL
 Oracle
 PostgreSQL
 SQLite
 IBM DB2 "

only MS SQL doesnt' exists in the list.
0
Alexander Eßer [Alex140181]Software DeveloperCommented:
only MS SQL doesnt' exists in the list.
Yes!?! If it's not in the list, it won't be officially supported...
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks, I am sad about that !
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.