I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?Tim,
there are many posibilities here.
Have a look at these articles, each of which detail reasons why the SQL
performance monitor counters may be missing and how to fix them:
http://support.microsoft.com/default.aspx?scid=kb;en-us;227662
http://support.microsoft.com/default.aspx?scid=kb;en-us;246328
http://www.extremeexperts.com/sql/faq/EnablingPerCounters.aspx
HTH,
Paul Ibison
No comments:
Post a Comment