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