Professional SQL Server 2008 Internals and Troubleshooting -- About the Authors -- Acknowledgments -- Contents -- Introduction -- WHO THIS BOOK IS FOR -- WHAT THIS BOOK COVERS -- HOW THIS BOOK IS STRUCTURED -- CONVENTIONS -- SOURCE CODE -- ERRATA -- P2P.WROX.COM -- Chapter 1: SQL Server Architecture -- DATABASE TRANSACTIONS -- THE LIFE CYCLE OF A QUERY -- THE SQLOS (SQL OPERATING SYSTEM) -- SUMMARY -- Chapter 2: Understanding Memory -- WINDOWS AND MEMORY -- SQL SERVER MEMORY -- SUMMARY -- Chapter 3: SQL Server Waits and Extended Events -- WAITS -- EXTENDED EVENTS -- EXAMINING WAITS WITH EXTENDED EVENTS -- SUMMARY -- Chapter 4: Working with Storage -- TYPES OF STORAGE -- STORAGE PERFORMANCE TESTING -- CONFIGURING SOFTWARE FOR STORAGE -- SUMMARY -- Chapter 5: CPU and Query Processing -- THE CPU -- THE CPU AND SQL SERVER -- SYSTEM ARCHITECTURE -- QUERY PROCESSING -- QUERY OPTIMIZATION -- QUERY PLANS -- EXECUTING YOUR QUERIES -- SQLOS -- SUMMARY -- Chapter 6: Locking and Latches -- TRANSACTIONS -- CONSEQUENCE OF CONCURRENT ACCESS -- LOCKING -- PESSIMISTIC CONCURRENCY -- OPTIMISTIC CONCURRENCY -- LATCHES -- SUB-LATCHES AND SUPER-LATCHES -- LATCHING IN ACTION -- SUMMARY -- Chapter 7: Knowing Tempdb -- OVERVIEW AND USAGE -- TROUBLESHOOTING COMMON ISSUES -- CONFIGURATION BEST PRACTICES -- SUMMARY -- Chapter 8: Defining Your Approach To Troubleshooting -- APPROACHING THE PROBLEM CORRECTLY -- DEFINING THE PROBLEM -- GATHERING DATA -- ANALYZING DATA -- TESTING SOLUTIONS -- TROUBLESHOOTING OTHER COMPONENTS -- SUMMARY -- Chapter 9: Viewing Server Performance with PerfMon and the PAL Tool -- PERFORMANCE MONITOR OVERVIEW -- GETTING STARTED WITH PERFMON -- GETTING MORE FROM PERFORMANCE MONITOR -- GETTING STARTED WITH PERFORMANCE ANALYSIS FOR LOGS (PAL) -- OTHER PERFMON LOG ANALYSIS TOOLS -- SUMMARY -- Chapter 10: Tracing SQL Server with SQL Trace and Profiler.

TRACING 101 -- THE ARCHITECTURE OF SQL TRACE -- EVENT CLASSIFICATION AND HIERARCHIES -- SQL TRACE CATALOG VIEWS -- SQL TRACE PROCEDURES AND FUNCTIONS -- SECURING SQL TRACE -- PROFILER -- SUMMARY -- Chapter 11: Consolidating Data Collection with SQLDiag and the PerfStats Script -- APPROACHING DATA COLLECTION -- WHAT IS SQLDiag? -- USING THE PERFSTATS SCRIPT -- SUMMARY -- Chapter 12: Introducing RML Utilities for Stress Testing and Trace File Analysis -- WHEN TO USE RML UTILITIES -- WHAT ARE RML UTILITIES? -- PERFORMANCE TESTING -- SUMMARY -- Chapter 13: Bringing It All Together with SQL Nexus -- GETTING STARTED -- DATA COLLECTION -- IMPORTING DATA -- AVAILABLE REPORTS -- EXAMPLE SCENARIO USING SQL NEXUS -- ADDING YOUR OWN REPORTS -- SUMMARY -- Chapter 14: Using Management Studio Reports and the Performance Dashboard -- USING THE STANDARD REPORTS -- USING THE PERFORMANCE DASHBOARD -- BUILDING CUSTOM REPORTS -- SUMMARY -- Chapter 15: Using SQL Server Management Data Warehouse -- INTRODUCING MANAGEMENT DATA WAREHOUSE -- IMPLEMENTING MDW -- REPORTING FROM MDW -- CUSTOM DATA COLLECTION AND REPORTING -- SUMMARY -- Index.