cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

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

Labels (1)
Attachments
Comments

Useful, thank you.

I tried to import this template via SAM and received the following error...

Template DL Error.png

That is because this template has been zipped. You won't be able to directly import it into SAM through the Thwack integration. You will need to download the template from here using your browser, then unzip the file, and upload/import it manually into SAM.

Import Template.png

Sounds like a plan, thanks Jeremy!

This template has been superseded by AppInsight for SQL included in the Server & Application Monitor (SAM) 6.0 RC available now!

All databases.png

Sign-up here and try it for yourself!

Version history
Revision #:
1 of 1
Last update:
‎04-04-2012 10:35 AM
Updated by: