End-to-End Troubleshooting Checklist : Slides, Scripts, Video, and Articles

Kevin Kline

Published On: December 17, 2015

Categories: Wait Stats, Monitoring 0


The Presentation: Slides, TSQL-Scripts, and Video

I've had quite a few inquiries about the slides, T-SQL scripts, and additional troubleshooting information following the presentation I gave to the DBA Fundamentals PASS Virtual Chapter in early December, 2015. I'm happy to report that I've finally collated all of the associated content from that presentation!

Click here to get the VIDEO. Want more? Then take a look at all videos made available by the DBA Fundamentals VC as well. There are lots of great virtual chapters presenting sessions every month. Take a look at them at the PASS Virtual Chapters page.

Click here to get the SLIDES. You might also want to look at my other slide decks as well.

Click here for the Transact-SQL troubleshooting SCRIPTS I used in the presentation.

SQL Server Troubleshooting White Papers and Articles

In the popular white paper entitled Troubleshooting SQL Server Wait Statistics, I take you through three scenarios in which a wait stats-only approach is insufficient or even harmful to detecting, diagnosing, and resolving performance problems on an instance of SQL Server. One of the most common questions that I get about the information in that white paper is "How do I do all of that cool stuff you do in SQL Sentry Performance Advisor (PA) with the native tools?" I've decided to kick off a series of blog posts to answer that question in a step-by-step fashion.

Since there are multiple articles in the series, the easiest way to find of the articles is with a site search on Troubleshooting SQL Server. Download them today!

Help Me Pay the Mortgage

It's no secret that I make a living making SQL Server performance monitoring & tuning products. With your help, I can continue to do that for years to come. At SQL Sentry, we make all of the hard work of detecting, diagnosing, and fixing SQL Server performance problems much, much easier than using the native tools that ship with SQL Server. If nothing else, I encourage you to download our popular and free tool Plan Explorer. After all, it's so free that we don't even ask for an email address. In addition, I'd be happy to help you out with trials and/or demos of our flagship performance monitoring product, Performance Advisor.

I hope that this content has been useful to you. Please drop me a note or connect with me via social media! Cheers,


Connect with me online! Facebook | Twitter | LinkedIn | Blog | SlideShare | YouTube | Google Author

Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.


Fighting Downtime and Slowdowns