Let’s take a look at this month’s participating blog posts:
Fellow Certified Master (MCM) Rob Farley (blog|@rob_farley) led off with Waiting, waiting…. Rob talks about what causes SQL Server (and computers in general) to be slow and how to baseline SQL Server waits to detect the cause of slowness.
Jeffrey Verheul (blog|@DevJef) explains some common wait types and how to effectively use sp_whoisactive* to find troubleshooting data.
Tracy McKibben (blog|@RealSQLGuy) offered up the best title of the month with Don’t Bring a Tank to a Prison Fight. Tracy calls back to a post he made 2 weeks prior where he provided a script for collecting wait information on your SQL Servers. In this post, he follows up by showing you some of the things you can do with the information it has been collecting (or will be if you are just now downloading his script).
Matan Yungman (blog|@MatanYungman) brought us back to CXPacket waits with Using CXPacket Waits to Detect Query Bottlenecks. Matan shares some of the information he learned from Paul White’s (blog|@SQL_Kiwi) PASS Summit presentation on parallel query execution and goes on to show how you can find bottlenecks by analyzing CXPacket waits.
Russ Thomas (blog|@SQLJudo) decided to focus on one specific wait type that gets very little press. What are you WAITFOR? takes a look at the WAITFOR wait type and what it may mean if you are seeing it a lot.
Dan Hess (blog|@SQLDCH/) shared a story of how his servers were adversely affected by the BACKUPTHREAD wait type and how he used recently learned skills to discover and deal with the problem in What’re we waitin’ fer?!?!?.
Good friend and former colleague Vicky Harp (blog|@vickyharp) shared some tactics for dealing with hung sessions from the rarely discussed external OS wait type in Killing Sessions with External Wait Types.
Amit Banerjee (blog|@banerjeeamit), another good friend (whose deep knowledge of SQL Server internals belies his youth), gave us Why was SQL waiting?. Amit told us how to use the data collected by and imported into SQLNexus to diagnose problems that show up through waits in SQL Server.
Thanks again to everyone involved! See you next month at the same bat Tuesday on a different bat blog.