How can we help?
Deadlocks
To query the Performance Store database for deadlocks, use:
select d.* from dbo.v_deadlocks d where 1 = 1 and d.sample_id = '[sample_id]' and d.server_name = '[server_name]' and d.database_name = '[database_name]' and d.victim = 1
Note, the xml_report column (the deadlock graph) in dbo.v_deadlocks is only available for SQL Server 2014 and newer.
A quick overview of the number of deadlocks can be seen on the Overview 1 dashboard:
In-depth information about the deadlocks can be seen on the Deadlocks dashboard.
To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.