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.