Configure Fields and Predicates for Multiple X-Events
Category:
monitoring-troubleshooting
I’m not always the best at learning to use graphical interfaces. Maybe that’s why I often don’t like them?
Tag: extended-events
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.
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.