Never-Before-Published Insiders’ Information for Troubleshooting SQL Server 2005.

This is the definitive guide to troubleshooting the Microsoft SQL Server 2005 database engine, direct from the people who know it most intimately: the people who wrote it, designed it, and support it. SQL Server expert Ken Henderson, author of the best-selling Guru’s Guides to SQL Server, has assembled a “dream team” of SQL Server developers and support engineers to provide in-depth troubleshooting and diagnostic information that has never been documented before: information that would be impossible to get without access to Microsoft’s own source code.

From caching to clustering, query processing to Service Broker, this book will help you address even the toughest problems with database engine operations. Each chapter begins with a brief architectural overview of a key SQL Server component, then drills down into the most common problems users encounter, offering specific guidance on investigating and resolving them. You’ll find comprehensive, in-depth chapters on

• Waiting and blocking

• Data corruption and recovery

• Memory

• Procedure cache issues

• Query processing

• Server crashes and other critical failures

• Service Broker

• SQLOS and scheduling

• tempdb

• Clustering

This is the indispensable resource for everyone who must keep SQL Server running smoothly: DBAs, database application developers, API programmers, and Web developers alike.

CD-ROM Contains the revolutionary SQL Server performance diagnostic tool, SQL Nexus^TM; TraceBuster^TM, one of the world’s fastest SQL Server Profiler trace reader/analyzers; DataDemon^TM, one of the fastest, most versatile file import utilities available; and sample code and scripts from the book.

Contents

About the Authors      ix

Preface      xii

Acknowledgments      xiv

1   Waiting and Blocking Issues      1

2   Data Corruption and Recovery Issues      47

3    Memory Issues      137

4   Procedure Cache Issues      183

5   Query Processor Issues      225

6   Server Crashes and Other Critical Failures      273

7   Service Broker Issues      331

8   SQLOS and Scheduling Issues      369

9   Tempdb Issues      411

10   Clustering Issues      425

The Aging Champion      441

Index      445

Amazon.com® Reader Reviews (Ranked by Helpfulness)

Average Amazon.com® Rating:  Based on 9 Ratings

cd missing code - 2008-02-26
Reviewer Rating:
The cd is missing the code from book.
The author/publisher is ignoring my email.

Expert level explanations with little emphasis on troubleshooting - 2009-01-08
Reviewer Rating:
The authors of this book are very knowledgeable about the SQL 2005 architecture. No doubt, their explanations of SQL 2005 and its architecture are of high level and that makes this book worth reading for those who want to expand their MS SQL knowledge.

As with many books with several authors, the book lacks a pinpoint focus. Namely, the book lacks focus on the troubleshooting SQL issues. The book is great on SQL architecture and diagnosing problems. But the book is rather skimpy on the actual troublehshooting methods. For example, on a chapter on troubleshooting Master database corruption, the author writes the following about Master database recovery (not restore):

"The steps to use setup to rebuild master are actually well documented in SQL Server Books Online...so I don't list them here. an important point for you to keep in mind is that after rebuilding master, you must apply any service packs.."

I don't think anyone buys SQL books to tell them to read the SQL Books Online. Ironically, the same author goes to great lengths to explain how to diagnose Master database problems and how to choose which methodology to fix it.

The same issue exists throughout most of the book.

But I am being very critical. I woudld give this book 4.5 stars for its depth of coverage and functional and theoratical expertise of the authors.

WOW! - 2007-09-14
Reviewer Rating:
I cannot believe how much you get for your money with this book. Very informative.

Excellent - 2009-05-25
Reviewer Rating:
Excellent is the word.... great book.... We miss Ken Henderson.... only you could make this possible...

He was the real GURU for all guru of sql server.......

MAJOR PROBLEM - NO CD, NO DOWNLOAD - 2008-11-10
Reviewer Rating:
The book itself is not bad. However not getting the accompanying materials is a major pain. Instead of an accompanying CD, they tell you to go to a web-site to download the materials. Except the materials are not on the web-site - there is no way to contact them about it - just a general runaround. MAJOR PROBLEM!!!

Browse Similar Topics

Top Level Categories:
Databases

Sub-Categories:
Databases > SQL Server