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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.