Chapter 6. Concurrency Problems

Ron Talmage

In this chapter:
New Tools for Troubleshooting Concurrency334
Troubleshooting Locking336
Troubleshooting Blocking340
Troubleshooting Deadlocking354
Troubleshooting Row-Versioning–Based Snapshot-Based Isolation Levels369
Summary393

You can tune your application’s database queries and optimize your database server, and still not have done enough to ensure good database performance in production. This is because problems can arise from concurrently (that is, simultaneously) executing queries on the system. In fact, no amount of single-query tuning can anticipate all the problems that might occur when queries are run simultaneously on a production database system. You can have the best-tuned, fastest-running ...

Get Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.