Professional SQL Server 2008 Internals and Troubleshooting

INTRODUCTION XXV

CHAPTER 1: SQL SERVER ARCHITECTURE 1

CHAPTER 2: UNDERSTANDING MEMORY 23

CHAPTER 3: SQL SERVER WAITS AND EXTENDED EVENTS 59

CHAPTER 4: WORKING WITH STORAGE 95

CHAPTER 5: CPU AND QUERY PROCESSING 137

CHAPTER 6: LOCKING AND LATCHES 185

CHAPTER 7: KNOWING TEMPDB 269

CHAPTER 8: DEFINING YOUR APPROACH TO TROUBLESHOOTING 305

CHAPTER 9: VIEWING SERVER PERFORMANCE WITH PERFMON AND THE PAL TOOL 329

CHAPTER 10: TRACING SQL SERVER WITH SQL TRACE AND PROFILER 369

CHAPTER 11: CONSOLIDATING DATA COLLECTION WITH SQLDIAG AND THE PERFSTATS SCRIPT 437

CHAPTER 12: INTRODUCING RML UTILITIES FOR STRESS TESTING AND TRACE FILE ANALYSIS 459

CHAPTER 13: BRINGING IT ALL TOGETHER WITH SQL NEXUS 481

CHAPTER 14: USING MANAGEMENT STUDIO REPORTS AND THE PERFORMANCE DASHBOARD 505

CHAPTER 15: USING SQL SERVER MANAGEMENT DATA WAREHOUSE 539

CHAPTER 16: SHORTCUTS TO EFFICIENT DATA COLLECTION AND QUICK ANALYSIS Wrox.com

INDEX 555