This help page is for version 5.1. The latest available help is for version 8.4.
How to Monitor Databases
There are a few simple approaches that work for easily monitoring databases.
The Microsoft SQL Server database publishes many performance counters. The Performance Monitor can monitor any of them. MSDN has a
recommended list of counters that can be monitored.
In addition, other database servers like MySQL can also be monitored via SNMP. Other databases likely have similar functionality.
The Execute Script monitor can periodically connect to a database and perform a check. The first example script shows how to do that. This method
even lets you easily check on a database value (table size for example).
Web Page Check
Create a web page that connects to the database and then returns something like "OK" or "Problem". The Web Page monitor could then check that page and alert
if it didn't see "OK". That web page could of course perform any sorts of checks that you need.