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