Ruby & Rails Bookstore

Professional SQL Server 2008 Internals and Troubleshooting

Book Description

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

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

More Details

• Binding Type: Paperback
• Number of Pages: 624
• Publisher: Wrox
• Release Date: January 07, 2010
• Keywords: ruby-on-rails

Similar Items

• SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server)
• Microsoft SQL Server 2008 R2 Unleashed
• Microsoft® SQL Server® 2008 Internals (Pro - Developer)
• SQL Server 2008 Administration in Action
• Microsoft SQL Server 2008 Management and Administration