Saturday, February 25, 2012

perfmon.exe doesn't have sqlserver object...

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...b;en-us;227662
http://support.microsoft.com/default...b;en-us;246328
http://www.extremeexperts.com/sql/fa...rCounters.aspx
HTH,
Paul Ibison

No comments:

Post a Comment