Performance Monitor locking counter
From: Robert Richards via SQLMonster.com (forum_at_SQLMonster.com)
Date: 02/09/05
- Next message: julie leck via SQLMonster.com: "windows 2003 and Sqlserver2000"
- Previous message: David Gugick: "Re: Errors in the trace from Enterprise manager"
- Next in thread: Andrew J. Kelly: "Re: Performance Monitor locking counter"
- Reply: Andrew J. Kelly: "Re: Performance Monitor locking counter"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 09 Feb 2005 23:29:06 GMT
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
- Next message: julie leck via SQLMonster.com: "windows 2003 and Sqlserver2000"
- Previous message: David Gugick: "Re: Errors in the trace from Enterprise manager"
- Next in thread: Andrew J. Kelly: "Re: Performance Monitor locking counter"
- Reply: Andrew J. Kelly: "Re: Performance Monitor locking counter"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
