Tracing Deadlock Graphs: Extended Events or Server Side Trace
Category:
monitoring-troubleshooting
Deadlock graphs are incredibly helpful for figuring out why queries are getting automatically killed off by SQL Server.
Tag: server-side-trace
Collecting the Blocked Process Report (XEvents and Server Side Trace)
Category:
monitoring-troubleshooting
I’m a big fan of the built-in Blocked Process Report in SQL Server. It’s come in handy for troubleshooting blocking situations for me many times.