Resolving locking issues with SQL Server 2008 R2 can be troublesome -- but it can also be surprisingly straightforward.

The SQL Server Utility Control Point, which is the heart of R2’s new multiserver management capabilities, allows you to monitor resource health across multiple SQL servers, but it currently ...