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/defaul...kb;en-us;227662
http://support.microsoft.com/defaul...kb;en-us;246328
http://www.extremeexperts.com/sql/f...erCounters.aspx
HTH,
Paul Ibison

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.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

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" <anonymous@.discussions.microsoft.com> wrote in message
news:1c53b01c4524b$06f48710$a401280a@.phx.gbl...
> 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?
If you are talking about SQL Server 2000, you may want to re-apply SP3a.
Failing this step, you may want to give this a read
http://support.microsoft.com/default...&Product=sql2k
Steve

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