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:
event id: 8313, source mssqlserver
Error in mapping SQL Server performance object/counter indexes to
object/counter names. SQL Server performance counters are disabled.
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.