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