?
Solved

Tools to keep database real time and inventory by IP address

Posted on 2014-08-04
14
Medium Priority
?
540 Views
Last Modified: 2014-08-11
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.
0
Comment
Question by:marrowyung
  • 7
  • 5
  • 2
14 Comments
 
LVL 14

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 40238610
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
 
LVL 25

Assisted Solution

by:Mohammed Khawaja
Mohammed Khawaja earned 800 total points
ID: 40238690
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
 
LVL 1

Author Comment

by:marrowyung
ID: 40240490
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 14

Accepted Solution

by:
Alexander Eßer [Alex140181] earned 1200 total points
ID: 40240639
0
 
LVL 1

Author Closing Comment

by:marrowyung
ID: 40250505
can they install on Windows ?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40250510
backend database can be  MS SQL ?
0
 
LVL 25

Expert Comment

by:Mohammed Khawaja
ID: 40251964
Not for Zabbix.
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40252462
Zabbix must installed on Linux and data host on MySQL ?
0
 
LVL 14

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 40252716
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
 
LVL 1

Author Comment

by:marrowyung
ID: 40252721
"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
 
LVL 14

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 40252734
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
 
LVL 1

Author Comment

by:marrowyung
ID: 40252737
"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
 
LVL 14

Expert Comment

by:Alexander Eßer [Alex140181]
ID: 40252803
only MS SQL doesnt' exists in the list.
Yes!?! If it's not in the list, it won't be officially supported...
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40254813
tks, I am sad about that !
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Recursive SQL is one of the most fascinating and powerful and yet dangerous feature offered in many modern databases today using a Common Table Expression (CTE) first introduced in the ANSI SQL 99 standard. The first implementations of CTE began ap…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question