Page 1 of 1

DataBase Parameters

Posted: Wed Oct 28, 2015 9:28 am
by wiproltdwiv
Hi ,

Can u please suggest me that how can i monitor below databases parameters:

Database:
Database Instance Name
Log file size(KB)
Log file used(KB)
Log File used %
Flush Log time
Log Cache ratio
Log Flush Wait Sec
Transactions Sec
Log Flush Sec

Tables:
Database Name
Table Name
Created Date
Total Rows
Data Space

Users:
Database
User Name
User Role

If yes then provide me feasible solution. If possible provide me plugins name as well.

Re: DataBase Parameters

Posted: Wed Oct 28, 2015 9:38 am
by tmcdonald
This is all going to be very heavily dependent on the database engine, such as MySQL, Postgres, MSSQL, etc. A great place to look would be the Nagios Exchange:

https://exchange.nagios.com/

There's no guarantee that there is a plugin for each and every metric you listed, but there's a lot on the Exchange and a good chunk of them are most likely present.