In this video, SQL Server MVP Kevin Kline discusses how to go about troubleshooting and performance tuning your Microsoft SQL Server without any paid professional tools. The main purpose for the video is to show you how to track down a particular performance problem that you are having on a SQL Server to its most basic cause. Kevin goes through his methodology for troubleshooting, which he has learned over the course of many years of trial and error. He also shares some of the powerful tools inside of SQL Server, which are extremely useful for performance tuning and troubleshooting such as DMVs, extended events, waits stats and more. Finally, at the end of the video, he briefly touches upon execution plans and provides you with a list of additional educational resources.
Note: eBook no longer available via Amazon. Email firstname.lastname@example.org if you are still interested in receiving a copy.