Wednesday, February 14, 2018

Where to find Deadlocks

All deadlock information is logged under the system_health extended event by default.  simply open system_health, right click package0.event_file > View Target Data...  At this point we can right click the grid, and select filter by this value.



Below is one way to filter for deadlocks.  I usually just filter on the field "name", operator "Contains", with a value of deadlock.

No comments:

Post a Comment