Troubleshooting Concurrency Issues
Concurrency issues can account for performance issues. In other words, whether a user of your database solutions is experiencing poor query performance because of inadequate hardware resources or contention, the end result is the same—poor query performance.
Your role as a DBA is to isolate whether the poor query performance is due to inadequate hardware resources, as covered in Chapter 1, or due to a concurrency issue.
So, where do you start? Well…what are your database users doing when there are concurrency issues? Waiting. So, why not start with SQL Server 2005 waits?
When a process connected to SQL Server 2005 tries to access a resource that is unavailable, it has to wait. The process is placed in a resource ...
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide 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.
