Orion Monitoring - Database.apm-template

Version 2

    Queries for monitoring the polling rate of your Orion Instance via the database.  Contains the following SQL queries:

     

    Number of Active Alerts

    select count(*) from AlertActive

    Returns the total number of alerts that are currently active

     

    Polling Rate - NPM

    select PropertyValue from EngineProperties where EngineID=1 and PropertyName='Orion.Standard.Polling'

    Returns the total polling rate for the NPM job thread (same as what is found in Settings --> Polling Details page)

     

    Polling Rate - SAM

    select PropertyValue from EngineProperties where EngineID=1 and PropertyName='APM.Components.Polling'

    Returns the total polling rate for the SAM job thread (same as what is found in Settings --> Polling Details page)

     

    Total Job Weight

    select PropertyValue from EngineProperties where EngineID=1 and PropertyName='Total Job Weight'

    Returns the Job Weight (same as what is found in Settings --> Polling Details page)

     

    Total Number of Nodes Monitored

    select count(*) from NodesData

    Tracks the total number of Nodes that are being monitored

     

    Polling Completion Rate

    select PollingCompletion from engines

    Tracks the Polling Completion rate

     

    Couple of notes on this:

    1) You will need to configure each component to your database.  Right now the SQL Server Instance is blank, and the catalog is set to 'northwind'.  99% chance that isn't your database

    2) This only tracks for the primary engine.  If you have multiple polling engines, you will need to copy this template (sans the number of active alerts) and change the queries used to reflect each additional poller.

     

    Why did you create this if all this information is available in the poller details page?

    Couple of reasons actually; first you now have the ability to track historically the polling rate/number of alerts/etc., whereas before this just a 'most recent' number.  Second, you now have the ability to alert off of these values as well.  So, if you wish to set an alert that says "email me if the polling completion drops below 98%", you now have the ability to do so.

     

    Can be used in conjunction with the Orion Website Monitor - Orion Monitoring - Website.apm-template