About the Book

We wrote this book to be a hands-on resource for advanced SQL Server DBAs.

This book doesn’t cover installations or how to get started: this is a top-notch, hands-on resource for SQL Server 2008 troubleshooting methods and tools.  We give you in-depth coverage of best practices based on our deep understanding of the internals of both SQL Server and the Windows operating system.

You’ll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.

The book:

  • Shows how to develop a methodology for troubleshooting based on a thorough understanding of SQL Server 2008 and Windows OS internals
  • Covers mastering specific troubleshooting tools and interpreting their output so that you can quickly identify and resolve any performance issue
  • Details all the free and proprietary tools that allow you to analyze and determine the source of a system-wide performance problem
  • Examines how it is critical for both SQL Server and Windows technologies to run smoothly in order to ensure effective SQL Server performance

This practical guide will help you pro-actively monitor and avoid SQL Server problems.  Buy your copy today!


Chapters include:

  1. SQL Server Architecture
  2. Understanding Memory
  3. SQL Server Waits and Extended Events
  4. Working with Storage
  5. CPU and Query Processing
  6. Locking and Latches
  7. Knowing Tempdb
  8. Defining Your Approach to Troubleshooting
  9. Viewing Server Performance with PerfMon and the PAL Tool
  10. Tracing SQL Server with SQL Trace and Profiler
  11. Consolidating Data Collection with SQLDiag and the PerfStats Script
  12. Introducing RML Utilities for Stress Testing and Trace File Analysis
  13. Bringing It All Together with SQL Nexus
  14. Using Management Studio Reports and the Performance Dashboard
  15. Using SQL Server Management Data Warehouse
  16. Shortcuts to Efficient Data Collection and Quick Analysis

You can get a look inside the book at Amazon now.