SQL server performance counters are missing

[former_member211576]

Hi experts,

  I run SQL server failover cluster and I install a name instance on passive node recently. I found SQL server performance counters are missing on default instance( which is running as my cluster service).

  I try to unload/lodctr sqlctrl.ini and reboot but the problem persists. And also I have checked startup account and it is in Adminsitrators group.

  I compared HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLServer \Performance\Library in these two nodes and I found many entries are missing in passive node. Apparently, lodctr does not update the registry successfully. Anyway, how do I fix the issue?

[former_member189546 · Accepted solution]

Hello,

Pleas try this

On each node of the cluster:

   Connect to the cluster with an account this is a local administrator

   Search for SQLCTR.INI file and note the location.

      It should be in the binn subdirectory where ever the SQL Server

      bits were installed

   Stop SAP and then stop the SQL Server service

   Open a command prompt

     Navigate to the directory where SQLCTR.INI was located.

     Run this command:  unlodctr mssqlserver

     And then run this command:  lodctr sqlctr.ini

       {you should see confirmation that they were actually loaded}

   Restart the SQL Server service and restart SAP

regards,

John Feely

[former_member211576 · Accepted solution]

Hi John,

  Thanks, my problem has been solved. Check it out here, http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/96f6c4bd-27ce-4654-b985-85f54...