Troubleshooting SQL Server: A Guide for the Accidental DBA
By Jonathan Kehayias and Ted Krueger


Troubleshooting SQL Server book

Buy from Amazon.com: $29.99 Kindle: $10.30
Buy from Amazon.co.uk: £11.70 Kindle: £6.77

Free PDF download

Three SQL Server MVPs provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".

Editorial Review

We spend much of our working life helping solve SQL Server-related performance problems, hands-on, during consulting, or on online forums. We've seen a few weird-and-wonderful issues but, mainly, it's the same problems and misconceptions time-and-again. This is our attempt to describe, diagnose, and solve the most common problems with SQL Server 2005, 2008, and 2008 R2.

First, we explain a basic approach to troubleshooting, the essential tools, and how rare it is that a problem can be diagnosed by looking at a single data point. The art of troubleshooting SQL Server is the art of first gathering various pieces of information and then assembling the "puzzle" to reveal a complete picture of what is going on inside a server, and so the root of the problem. Next, we explore the areas in which problems arise with alarming regularity:

In each case, the book describes the most common problems, why they occur, and how they can be diagnosed using tools such as the Performance Monitor, Dynamic Management Views, server-side tracing, and more. Finally, it provides practical solutions for removing root causes, rather than "papering over the cracks".

The steps and techniques described are ones we use day-to-day to troubleshoot real SQL Server performance problems. With them, we hope you can solve performance problems quickly and accurately, and tame your unruly SQL Servers.

Buy from Amazon.com: $29.99
Free eBook download

SQLServerCentral.com

Visit the #1 education and community site for the SQL Server Community, for articles, resources, forums, sample scripts and book reviews.

SQLServerCentral.com

Ask.SqlServerCentral.com

Visit our rapid fire stackoverflow-style Q&A site for all things SQL Server. Ask questions, answer them, vote good answers up and bad ones down, build your reputation in badges.

ask.SqlServerCentral.com

Simple-Talk.com

Visit our online technical journal and community hub for SQL Server, .NET and Exchange professionals.

Simple-Talk.com

Connect with Red Gate