- Pages/sec
- Bytes Total /sec
- % Disk Time
- Avg Disk Queue Length
- % Processor Time
- Full Scan/sec
- Buffer cache hit ratio
- Transactions per sec
- Log growths
- User connections
- Average latch wait time
- Number of deadlocks per second
- Average wait time ms
- Memory grants pending
There are many performance objects - so how do we know which to use - what is useful inour scenario? The best advise is to learn from other people, hence above Kevin Klines's suggested list.
No comments:
Post a Comment