Example SQL Database Status.apm-template

Version 1

    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