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