Professional SQL Server 2008 Internals and Troubleshooting

Professional SQL Server 2008 Internals and Troubleshooting

• New
• Mint Condition
• Dispatch same day for order received before 12 noon
• Guaranteed packaging
• No quibbles returns

<b>A hands-on resource for SQL Server 2008 troubleshooting methods and tools</b> <p>SQL 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.</p> <p>You'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.</p> <p>Topics Covered:</p> <ul> <li>SQL Server Architecture</li> <li>Understanding Memory</li> <li>SQL Server Waits and Extended Events</li> <li>Working with Storage</li> <li>CPU and Query Processing</li> <li>Locking and Latches</li> <li>Knowing Tempdb</li> <li>Defining Your Approach To Troubleshooting</li> <li>Viewing Server Performance with PerfMon and the PAL Tool</li> <li>Tracing SQL Server with SQL Trace and Profiler</li> <li>Consolidating Data Collection with SQLDiag and the PerfStats Script</li> <li>Introducing RML Utilities for Stress Testing and Trace File Analysis</li> <li>Bringing It All Together with SQL Nexus</li> <li>Using Management Studio Reports and the Performance Dashboard</li> <li>Using SQL Server Management Data Warehouse</li> <li>Shortcuts to Efficient Data Collection and Quick Analysis</li> </ul> <p><b>Note:</b> CD-ROM/DVD and other supplementary materials are not included as part of eBook file.</p>