i****a
发帖数: 36252 | 1 Where can I find a list of MS SQL performance counters and MS's recommended
values for each?
I've seen it before but can't find it now... | g***l
发帖数: 18555 | 2 你看哪一个COUNTER啊，问我好了,LOL，无非是CPU, MEMORY,I/O，要是看那些LATCHES, LOCKS,BUFFER啥的会看花眼的也找不到问题的所在 | i****a
发帖数: 36252 | 3 the thing is, I was given a table of counters and "expected values". boss
wants me to valid that "expected values" against M$'s office
recommendation ah...
【在 g***l 的大作中提到】
: 你看哪一个COUNTER啊，问我好了,LOL，无非是CPU, MEMORY,I/O，要是看那些LATCHES, LOCKS,BUFFER啥的会看花眼的也找不到问题的所在
| g***l
发帖数: 18555 | 4 没有什么EXPECTED VALUE，这种大面积撒网没什么意义，比如MAX I/O WAIT，说是5正
常，我这平均25都是正常，好几个月平均125 SERVER也没事，只有到了3000以上才会
SERVER TIMEOUT。而且你是一分钟平均值啊，一小时平均值，还是一天的平均值，变化
都很大的，关键还是看综合PERFORMANCE，有没有CPU. MEM和I/O的PRESSURE
【在 i****a 的大作中提到】
: the thing is, I was given a table of counters and "expected values". boss
: wants me to valid that "expected values" against M$'s office
: recommendation ah...
| S*****0
发帖数: 538 | 5 You might want to take a look on sys.dm_os_performance_counters.
【在 i****a 的大作中提到】
: the thing is, I was given a table of counters and "expected values". boss
: wants me to valid that "expected values" against M$'s office
: recommendation ah...
|
|
