Agent not running

Comments are closed
How can we help?
< All Topics
Print

Agent not running

SQL Servers where the SQL Agent is not running.

To query the Performance Store database for SQL Servers where the SQL Server agent is not running, use:

select s.*
from dbo.servers s
where s.agent_running = 0

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents