Performance object "SQL Server" does not exist

Hi,

I am running SQL Server 2000 SP4 on a Windows Server 2003 64bit Edition. I indend to monitor the SQL Server performance in the Windows Performance Monitor however neither the SQL Server performance object nor the associated counters are visible.

Any idea why and how I possibly install it?

Thanks in advance,

Greg

When ever I've had the counters drop off either a SQL Server restart or an OS restart will resolve the issue.|||

Thanks.

I did so however the counters haven't emerged after the restart of the both.

Any help would be appreciated.

Greg

|||

Come on........! The suggestion to restart the servers shows little respect towards this issue.

Would somebody please help?

Thanks.

|||

Is the SQL server a 64 bit edition?

THe issue is you can only see 64bit related counters and only way you load the 32bit version of PERFMON to be able to read the 32 bit SQL Server counters, that is easily done by running this: mmc /32 perfmon.msc.

|||

mmc /32 perfmon.msc was the solution.

Thanks!