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...
没有什么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
13 楼
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...