Sunday 28 May 2017

Deadlock information from "system health" extended events


In SQL 2012 and above versions we can reterive deadlock information without enabling trace flags. Steps as below.

1) Go to Management -> Extended Events -> Sessions -> system_health

2) Right click on “package0.event_file”

3) Select “View Target Data..”

4) Click on “Filters” from task bar as below



5) Apply filter on Name field with “xml_deadlock_report”


6) Select on any deadlock based on timestamp, select deadlock tab for more info.


No comments:

Post a Comment