I just concluded my presentation on “Debugging the Deadlock for the Scheduler” at SQL Saturday 76 over a Lync meeting. The WiFi and Lync gods decided to be benevolent today and let me present without an untoward incident! As always it was fun to demonstrate the use of a debugger…
The attempt of the presentation was to demonstrate what can be done proactively and reactively when dealing with a deadlocked schedulers condition.
A special thank you is due to all the sponsors without whom the event today wouldn’t have been possible: Microsoft New Zealand, RedGate, SQL Pass, New Zealand MS Communities and SQL Services!
The slide deck used for presentation today is available on Slide Share and is embedded below:
The demo files used are available at SkyDrive in the file SQLSat76_Demo.zip The walkthrough for the debugging that I explained along with the use of the Powershell script to automatically collect DMV outputs based on messages in the Windows Application event log are available using the posts available under the walkthroughs link below as well as the zip file mentioned above.
And last but not the least, a big Thank You to Dave [Twitter | Blog] for helping arrange all the logistics so that I could present and also for giving me this opportunity!
Resources:
Whitepaper: How To Diagnose and Correct Errors 17883, 17884, 17887, and 17888
http://msdn.microsoft.com/en-us/library/cc917684.aspx
Walkthroughs
https://troubleshootingsql.com/tag/deadlocked-schedulers/
WinDBG
http://msdn.microsoft.com/en-us/windows/hardware/gg463009
Microsoft Public Symbol Server
http://msdl.microsoft.com/download/symbols
KB: New concurrency and scheduling diagnostics have been added to SQL Server
http://support.microsoft.com/kb/319892/en-us
Cheers!
