Description
This alert counts the number of active (non-background) sessions in the instance and alerts accordingly. Some of our customers have used this to warn them when an application connection pool increases suddenly.
Alert Definition
To create the alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Multiple Numeric Return. Configure the alert with values similar to these:
Alert Name: Active Session Count
Execution Interval: 10 minutes
Notification Text: The following Ignite monitors are currently down and not collecting data.
SQL Statement:
select count(1) from sys.dm_exec_requests where status <> 'Background'
Execute Against: Monitored Instance
Units: Active User Sessions
High Threshold: Min <whatever needed by customer>, Max empty
