Performance Monitor locking counter

I have a Performance Monitor counter set up with the idea of monitoring
locking. I have set the following:
SQLServer: Locks
Average Wait Time (ms) _Total
SQLServer: Locks
Average Wait Time (ms) Table
SQLServer: Locks
Average Wait Time (ms) Key
SQLServer: Locks
Average Wait Time (ms) Page
I ran it for 24 hours and everthing was zero (average, minimum, maximum),
for every counter specified above. I was also running separate counters
relating to Physical Disk, CPU, Memory, and all returned data.
Is it possible that they would all be zero, when there was tons of reads
and writes happening?
Message posted via http://www.sqlmonster.com
I was never able to determine why but have found that that particular
counter almost always shows 0 and Isimply ignore it. The other lock
counters should be fine.
Andrew J. Kelly SQL MVP
"Robert Richards via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:3ff52afa960842739a36bcf118f643b2@.SQLMonster.c om...
>I have a Performance Monitor counter set up with the idea of monitoring
> locking. I have set the following:
> SQLServer: Locks
> Average Wait Time (ms) _Total
> SQLServer: Locks
> Average Wait Time (ms) Table
> SQLServer: Locks
> Average Wait Time (ms) Key
> SQLServer: Locks
> Average Wait Time (ms) Page
> I ran it for 24 hours and everthing was zero (average, minimum, maximum),
> for every counter specified above. I was also running separate counters
> relating to Physical Disk, CPU, Memory, and all returned data.
> Is it possible that they would all be zero, when there was tons of reads
> and writes happening?
> --
> Message posted via http://www.sqlmonster.com