Chapter 6. Concurrency Problems
—Ron Talmage
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.