SQL Performance Counters missing

[wellsm]

Help..
We are running 3 Instances of SQL on a DL 580 G2. After Compaq support pack 6.20 the SQL performance counters are now missing. We have tried endless fixes including rebuilding all performance counters, rebuilding the sql registry and manualy loading the performance counters with the LODCTR SQLCTR.ini utility. But no success.
Please help

[Jon Finley]

See if you can get to the following HP article:

http://support1.itrc.hp.com/service/cki/docDisplay.do?docLocale=en_US&docId=200000064216587

If not, I post it directly.

It addresses a problem similar to yours and may provide the basis for your fix.

Jon

[Jon Finley]

Maybe an easier link.. from the MS side:

http://support.microsoft.com/default.aspx?scid=kb;en-us;246328

Jon

[wellsm]

Thanks jon,

But unfortunatly that has not fixed our problem. The SQL performance counters come up with errors in the application log when I try to load them manually and the registry is not being updated. The SQL service account that SQL runs with has full admin rights on the Server so it can not be a registry permisions problem....
But it deffinatly will not update the registry when performance counters are loaded frorm the command line.
Cheers

[Jon Finley]

What exactly are the errors you're getting in the application log?

Jon

[Ola Hallengren]

I would like to reply that I have the same problem with missing performance counters on a sql server 2000 SP3. The server is a DL380 G3.

Is there a solution to that?

[wellsm]

Thanks for all responces.

The problem was EMC managment software not allowing the Microsoft performance counters to write to the registry when manaully rebuilding the performance counters.
Simple solution in the end. Stop all management software services and then manually rebuild the Performasnce counter http://support.microsoft.com/?id=300956

[David Bernero]

I had a similar problem with my DL380 G3 system. In addition to no SQL counters, I was getting a 1010 event id for perflib in the event viewer. I contacted Microsoft to send me the hotfix identified in KB819716. The hotfix is designed to fix a problem with the TCP/IP counters, but installing this kept the 1010 error from showing up and allowed all of my SQL counters to be visible.
I still do not see the TCP counter available, but I don't use it anyway. I think the problem is that the network adapters in the DL380's send back a string that is too long to perfctrs.dll (the file that KB819716 replaces) and this causes other counters not to work. This fix will be available in SP5 I believe, but I did not want to wait for it.