tag:blogger.com,1999:blog-495177919198719500.post7783266728477913977..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: How to capture SQL Server PerfMon Counters without running Performance MonitorSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-495177919198719500.post-20961186532960596962011-01-06T08:58:08.625-08:002011-01-06T08:58:08.625-08:00Great for knowing what components are actually doi...Great for knowing what components are actually doing. For example is your disk mainly reading or writing.<br /><a href="http://www.joovyscooter.com/" rel="nofollow">-</a>TomAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-61302632708089494162010-02-17T11:19:01.089-08:002010-02-17T11:19:01.089-08:00Troy: Thanks for your useful comment!Troy: Thanks for your useful comment!Suprotim Agarwalhttps://www.blogger.com/profile/08349831623922214390noreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-22640202970093199512010-02-17T07:25:07.863-08:002010-02-17T07:25:07.863-08:00One thing you need to be cautious about when using...One thing you need to be cautious about when using this DMV is that many of these counters are incremental from the last time the SQL Server was started. Themselves, the numbers may not mean anything. It's only when you establish a baseline and analyze "further" activity, that this wonderful DMV shows it's true worth.<br /><br />BTW, in SQL Server 2000, one can query "master.dbo.sysperfinfo" to obtain the same information.Troyhttp://troygallant.comnoreply@blogger.com