性能计数器最佳实践.doc
5墨值下载
Performance Counter Guidance
Table of Contents
Performance Non-Disk Counters....................................................................................................................... 4
Performance Disk Counters.............................................................................................................................. 5
SQL Performance Counters.............................................................................................................................. 7
Disclaimer
! "#$%!& %'%!%&# &!# ()%!(#*+ ")%&" # & &#&%,)%%&
#**!()&" # &' -,%,&)!, (%&!' -,%,.#!!./) (/##&+ "#&+
$&,%)%%0'%!! '*%,&*(,&1(& *%, )%'*%,/##&%! "
%)#&#*+"&%!!" #'#(*#'(' !%*%#&,& &2&"&1%%&&& %-%&!)#**
! "%*#*%" #&+!'%#*&,% &!%3(%&#*,##1%! #&+,##1%!
/)#! %-%%!(*&1" * !! "(!%,## ' "!/)%)%&#&# & " &#
&%1*1%&% )% (!# &#!&1 ( " & &&% &/))%(!% "
'%" #&% "&" # &#-#*#*%)%%&)%&" # &)%%& (*,&*(,%%)&#*
&#(#%! +' 1#')#*% !)#&1%!#%'% ,#**+#,,%, )%&" # &
)%%& ! "#+#$%' -%%&!#&,4 )#&1%!&)%! "/#%' ,(5!6#&,4
)%' 1#5!6,%!%,)%%&##&+%
7
8
79 " 9 / &
$8
/!3*!
8 :
8 !3* !
/8;<2=<5
><6!3*!?7
)7'
So despite the hesitation to provide any specic values, we
will attempt to note some thresholds where a given counter starts to attract the
interest of those who have been working some of these cases over the past several
years. Hopefully this will provide you some guidance in things that stand out. But
ultimately, you will need to look for other counters that also seem out of range so that
you can start developing a pattern of indicators that point to a particular type of
problem.
3 7
7/9
84 If you focused solely
on a particular counter (or a few counters) you might come to some very dierent
conclusions about what the problem is, and you could very likely be wrong.!
?
@
In the ideal situation, the change in the counters that indicate the cause of the problem
should lead the counters showing the aect, but due to the granularity used to capture
Performance Monitor data some of these distinctions can be lost.
>A 8 7
7
B
of 16
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
相关文档
评论