SQL Server - sql 2005 performance counter missing

Asked By John Doe on 20-Sep-07 05:25 AM
I am pretty sure the performance counter registry is fine, and also sure it
is not a user right since even if I added the service account to admins
group, the problem persists.

event log gives:

1
event id: 8313, source mssqlserver
Error in mapping SQL Server performance object/counter indexes to
object/counter names. SQL Server performance counters are disabled.
2
event id: 3409, source mssqlserver
Performance counter shared memory setup failed with error -1. Reinstall
sqlctr.ini for this instance, and ensure that the instance login account has
correct registry permissions.

So what's wrong here?

Thanks in advance.




Uri Dimant replied on 20-Sep-07 05:32 AM
John
May be Tony answers the question here
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/12/02/missing-perfmon-counters-using-64-bit-windows-mmc-32-perfmon-msc.aspx
John Doe replied on 20-Sep-07 07:07 AM
Thanks, but that does not apply to my case.
The event log might be a clue for what went wrong, for someone who wrote the
performance counter dll, not me, ;-)


http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/12/02/missing-perfmon-counters-using-64-bit-windows-mmc-32-perfmon-msc.aspx
it
John Doe replied on 25-Sep-07 12:05 AM
Looks like this is a mined aera, nobody want to touch it, ;-)



the
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/12/02/missing-perfmon-counters-using-64-bit-windows-mmc-32-perfmon-msc.aspx
sure
admins
Reinstall
account