A hands-on resource for SQL Server 2008 troubleshooting methods and tools SQL Server administrators need to ensure that SQL Server is still running 24 / 7. Topics Covered: SQL Server Memory Architecture Understanding the SQL Server Extended Events Waiting and Working with CPU Storage and Query Processing Lock and crocheted Knowing Tempdb Defining Your Approach To Solving Problems Viewing Server Performance with PerfMon and PAL Tool Tracing SQL Server with SQL Profiler Trace and Data Consolidation Collection with SQLDiag and PerfStats Script Introducing RML Utilities for Stress Testing and Trace File Analysis Bringing It All Together with Nexus Using SQL Management Studio and Performance Dashboard Reports Using SQL Server Management Data Warehouse Efficient Shortcuts to Quick Data Collection and Analysis Note: CD-ROM/DVD and other additional materials not included as part of eBook file.