文档介绍：Kalen Delaney
Inside Microsoft SQL Server 2005
Query Tuning and Optimization
Microsoft Press
2007
Kalen Delaney
Inside Microsoft SQL Server 2005:
Query Tuning and Optimization
Publisher: Microsoft Press
Pub Date: September 26, 2007
Print ISBN-10: 0-7356-2196-9
Print ISBN-13: 978-0-7356-2196-1
Table of Contents
Table of Contents 3
Foreword 5
Acknowledgments 6
Introduction 9
Chapter 1. A Performance Troubleshooting Methodology 16
Factors That Impact Performance 17
Troubleshooting Overview 30
Summary 76
Chapter 2. Tracing and Profiling 77
SQL Trace Architecture and Terminology 77
Security and Permissions 80
Getting Started: Profiler 81
Server-Side Tracing and Collection 90
Troubleshooting and Analysis with Trace 101
Tracing Considerations and Design 120
Auditing: SQL Server's Built-in Trace 124
Summary 126
Chapter 3. Query Execution 128
Query Processing and Execution Overview 128
Reading Query Plans 132
Analyzing Plans 142
Summary 226
Chapter 4. Troubleshooting Query Performance 227
Compilation and Optimization 227
Detecting Problems in Plans 247
Monitoring Query Performance 250
Query Improvements 255
Query Processing Best Practices 303
Summary 306
Chapter 5. Plan Caching and pilation 307
The Plan Cache 307
Caching Mechanisms 309
Plan Cache Internals 331
Objects in Plan Cache: The Big Picture 343
Multiple Plans in Cache 345
When to Use Stored Procedures and Other Caching Mechanisms 346
Troubleshooting Plan Cache Issues 347
Summary 364
Chapter 6. Concurrency Problems 366
New Tools for Troubleshooting Concurrency 367
3
Troubleshooting Locking 369
Troubleshooting Blocking 373
Troubleshooting Deadlocking 389
Troubleshooting Row-Versioning–Based Snapshot-Based
Isolation Levels 405
Summary 430
Additional Resources and References 431
Abou