Skip to main content
How can we help?
< All Topics
Print

SQL Server restart

If a production SQL Server machine is rebooted or the SQL Server service is restarted, this alert will be triggered.

To query the Performance Store database for SQL Server restarts, use:

select *
from dbo.v_servers s
where s.last_restart > dateadd(minute, -10, getutcdate())
and s.is_production = 1

To see when SQL Servers was last restarted, see the Servers dashboard.

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

Table of Contents