marrowyung
asked on
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
![Avatar of Alex [***Alex140181***]](https://filedb.experts-exchange.com/files/public/2022/11/13/8257e912-ee3c-4a93-9df0-fe9a8a1515cf.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can they install on Windows ?
ASKER
backend database can be MS SQL ?
Not for Zabbix.
ASKER
Zabbix must installed on Linux and data host on MySQL ?
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?!
ASKER
"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?
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?
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
ASKER
"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.
MySQL
Oracle
PostgreSQL
SQLite
IBM DB2 "
only MS SQL doesnt' exists in the list.
only MS SQL doesnt' exists in the list.Yes!?! If it's not in the list, it won't be officially supported...
ASKER
tks, I am sad about that !
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)...