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

Database in non-operational state

To query the Performance Store database for databases with a non-operational state, use:

select d.*
from dbo.v_databases d
where d.state_desc in ('RECOVERY_PENDING', 'SUSPECT', 'EMERGENCY')

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