Missing counters in Performance Monitor

Im missing all SQL Server counters in the Performance Monitor

and have looked at article: http://support.microsoft.com/default...NoWebContent=1

but this article refers to SQL 7...I have 2K with SP3 and MS03-031

How can I get my counters ? thanks

Follow the instruction in the article to add counters. The .ini file is located in

C:\Program Files\Microsoft SQL Server\MSSQL\Binn

I found 2 files:one is called "sqlctr.ini" and the other is called "sqlctr.h"...should I just delete the sqlctr.h file ?
and why would it have an extension of "h" ?

Use SQLCTR.INI with loadctr.

.h files are C or C++ header files.

This file has all constants.

If you open the file you can see the following lines

// This file is generated by the description file processor.
// Please do not edit.

isql ?

Start - Run - Cmd

I opened the cmd window and changed the directory to where the sqlctr.ini resides (D:\Program Files\Microsoft SQL Server\MSSQL\Binn)

then ran "unlodctr mssqlserver"
then ran "lodctr D:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlctr.ini"

then opened and closed performance monitor...but still cant find my counters ?...any other ideas ?...do I need to stop and start SQL Server ?

thank you

In addition I found this msg in the sql server log:
"performance monitor shared memory setup failed: -1"

any idea if this is related ?

Yes, have to restart sql service.

the counters are still not showing up

Did you reboot the server or just restarted SQL Server?


Check if the counters are listed in registry

http://support.microsoft.com/default...;en-us;q127207

thank you, but that article applies to NT...whereas I have Windows 2K server

Should work as well.