SQL Server Locks Object -> Average Wait Time
This counter measures the average amount of time, in milliseconds, that a user is waiting for a lock. Over time it is a good indicator for a general performance problem or if a performance issue is specific to one user. Locks are inevitable but a sometimes a blocking or a deadlock can skew the values. Having said that, less this wait the better it is.
This entry was posted on Tuesday, January 15th, 2008 at 01:51 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.