Tags
Language
Tags
March 2024
Su Mo Tu We Th Fr Sa
25 26 27 28 29 1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31 1 2 3 4 5 6

Professional SQL Server 2008 Internals and Troubleshooting [Repost]

Posted By: AlenMiler
Professional SQL Server 2008 Internals and Troubleshooting [Repost]

Professional SQL Server 2008 Internals and Troubleshooting by Steven Wort
Wrox | January 07 2010 | ISBN: 0470484284 | Pages: 624 | PDF | 14.1 MB

A hands-on resource for SQL Server 2008 troubleshooting methods and tools. 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.

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.

Topics Covered:

SQL Server Architecture
Understanding Memory
SQL Server Waits and Extended Events
Working with Storage
CPU and Query Processing
Locking and Latches
Knowing Tempdb
Defining Your Approach To Troubleshooting
Viewing Server Performance with PerfMon and the PAL Tool
Tracing SQL Server with SQL Trace and Profiler
Consolidating Data Collection with SQLDiag and the PerfStats Script
Introducing RML Utilities for Stress Testing and Trace File Analysis
Bringing It All Together with SQL Nexus
Using Management Studio Reports and the Performance Dashboard
Using SQL Server Management Data Warehouse
Shortcuts to Efficient Data Collection and Quick Analysis