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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 你看哪一个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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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 的大作中提到】![](/moin_static193/solenoid/img/up.png) : 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...
|
|