Chapter 1. A Performance Troubleshooting Methodology
Factors That Impact Performance
Troubleshooting Overview
Summary
Chapter 2. Tracing and Profiling
SQL Trace Architecture and Terminology
Security and Permissions
Getting Started: Profiler
Server-Side Tracing and Collection
Troubleshooting and Analysis with Traces
Tracing Considerations and Design
Auditing: SQL Server’s Built-in Traces
Summary
:: Course ::
Chapter 3. Query Execution
Query Processing and Execution Overview
Reading Query Plans
Analyzing Plans
Summary
Chapter 4. Troubleshooting Query Performance
Compilation and Optimization
Detecting Problems in Plans
Monitoring Query Performance
Query Improvements
Query Processing Best Practices
Summary
Chapter 5. Plan Caching and Recompilation
The Plan Cache
Caching Mechanisms
Plan Cache Internals
Objects in Plan Cache: The Big Picture
Multiple Plans in Cache
When to Use Stored Procedures and Other Caching Mechanisms
Troubleshooting Plan Cache Issues
Summary
:: Course ::
Chapter 6. Concurrency Problems
New Tools for Troubleshooting Concurrency
Troubleshooting Locking
Troubleshooting Blocking
Troubleshooting Deadlocking
Troubleshooting Row-Versioning–Based Snapshot-Based Isolation Levels
Summary
Additional Resources and References
About the Authors
Kalen Delaney
Sunil Agarwal
Craig Freedman
Adam Machanic
Ron Talmage
Additional Resources for Developers: Advanced Topics and Best Practices
Additional SQL Server Resources for Developers
Prepare for Certification with Self-Paced Training Kits: Official Exam Prep Guides—Plus Practice Tests
2007 Microsoft® Office System Resources for Developers and Administrators
:: Course ::
Additional Resources for Developers from Microsoft Press
Visual Basic 2005
Visual C# 2005
Web Development
Data Access
SQL Server 2005
Other Developer Topics
More Great Developer Resources from Microsoft Press
Developer Step by Step
Developer Reference
Focused Topics
Index
Programme scope, delivery arrangements and suitability are confirmed during enquiry.