This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Example SQL Database Status.apm-template

This example application template monitors the status of a specific SQL database, returning the following numerical value for the status as well as the description of that status in the message field. In this example the database name is "mbussey1". Change the database name within the application template to the actual name of the database you wish to monitor.

First column (state) will be used as statistical value and user should set threshold to go to critical if it’s higher than 0. According to documentation:

Database state:

0 = ONLINE

1 = RESTORING

2 = RECOVERING

3 = RECOVERY_PENDING

4 = SUSPECT

5 = EMERGENCY

6 = OFFLINE

Example SQL Database Status.apm-template.zip