Professional SQL Server 2008 Internals and Troubleshooting

bA hands-on resource for SQL Server 2008 troubleshooting methods and tools/bpSQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.pYou'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.pTopics Covered:ulliSQL Server ArchitectureliUnderstanding MemoryliSQL Server Waits and Extended EventsliWorking with StorageliCPU and Query ProcessingliLocking and LatchesliKnowing TempdbliDefining Your Approach To TroubleshootingliViewing Server Performance with PerfMon and the PAL ToolliTracing SQL Server with SQL Trace and ProfilerliConsolidating Data Collection with SQLDiag and the PerfStats ScriptliIntroducing RML Utilities for Stress Testing and Trace File AnalysisliBringing It All Together with SQL NexusliUsing Management Studio Reports and the Performance DashboardliUsing SQL Server Management Data WarehouseliShortcuts to Efficient Data Collection and Quick Analysis/ulpbNote:/b CD-ROM/DVD and other supplementary materials are not included as part of eBook file.