How do I fix a “Performance counter registry hive consistency” when installing SQL Server 2008 R2 SP2 Express Edition?
You are attempting to install the SQL Server 2008 R2 SP2 Express edition when you receive an error similar to the following:
- "Performance counter registry hive consistency check" failed. The performance counter registry hive is corrupted."
- "Performance counter registry hive consistency."
You can resolve this issue by rebuilding the performance counters in Windows.
Please use the following steps:
- Run Command Prompt as Administrator ( Right-click Command Prompt; select "Run as Administrator")
- Enter the following command then press enter: lodctr /r
After running the lodctr command, you will see output as to whether this command succeeded or not.
If the command reports success, you should verify that the Windows performance counters are actually restored.
Now, Restart the system and attempt to install SQL Server 2008 R2.
Hope this Helps.