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 ...