CHAPTER 1 SQL Server Architecture.

CHAPTER 2 Understanding Memory.

CHAPTER 3 SQL Server Waits and Extended Events.

CHAPTER 4 Working with Storage.

CHAPTER 5 CPU and Query Processing.

CHAPTER 6 Locking and Latches.

CHAPTER 7 Knowing Tempdb.

CHAPTER 8 Defi ning Your Approach To Troubleshooting.

CHAPTER 9 Viewing Server Performance with PerfMon and the PAL Tool.

CHAPTER 10 Tracing SQL Server with SQL Trace and Profiler.

CHAPTER 11 Consolidating Data Collection with SQLDiag and the PerfStats Script.

CHAPTER 12 Introducing RML Utilities for Stress Testing and Trace File Analysis.CHAPTER 13 Bringing It All Together with SQL Nexus.

CHAPTER 14 Using Management Studio Reports and the Performance Dashboard.

CHAPTER 15 Using SQL Server Management Data Warehouse.

CHAPTER 16 Shortcuts to Effi cient Data Collection and Quick Analysis.

INDEX.