Two Scripts That Help You Monitor Deadlocks with Extended Events

(Michael J. Swart) I want to use extended events to store recent deadlock graphs. And I want to create an asynchronous file target instead of using the existing system_health session. I don’t like the system_health target for a couple reasons. It’s too slow to query and it rolls over too quickly and

Read More - Register for Free Membership