SQL

Performance counter registry hive consistency check when installing SQL Server on Windows

Performance counter registry hive consistency check when installing SQL Server on Windows

Like I mentioned last week, I'll be covering different SQL Server installation related problems and different troubleshooting tips to resolve the problem. Last week we discussed how to manage SQL Server stopped working error and went through different steps to fix it. So this week I'm discussing about another common error that you get while troubleshooting SQL Server 2008 R2 / 2012, and that is about Performance counter registry hive consistency check error. Let's discuss a little background of this error message.

Performance counter registry hive consistency check failed

Basicallywhen we try to install SQL, it will run some rules to check if your system meets all the requirement to run the SQL Server 2008 successfully. During that process as you can see in the screenshot the installation will fail at this point. You cannot proceed further.

You do not need the Performance counter in all cases, in some you can just skip it. During the installation, a set of performance counters will be used to monitor the performance of the data flow engine.

According to TechNet the best example is as of the “Buffers spooled” This counter is to determine whether data buffers are being written to disk temporarily while a package is running. But like I said some application that runs with SQL doesn't really need these. It's mostly used for stand alone SQL on a data server which requires a lot of monitoring. So if you want to just skip the Performance counter  consistency check you can start the SQL Server install with the following switch value.

C:\Downloads\setup.exe /ACTION=install /SKIPRULES=PerfMonCounterNotCorruptedCheck

Replace the location with where you have the installation files.

Rebuild the Performance Counter

Once you start the setup with this switch value it should skip that step and continue with the installation. So this is one way to get around this error message. The other way which is also mentioned in the Microsoft KB is to Rebuild the Performance Counter.

I have seen this working onolder version of Windows like XP and Server 2003but I hardly seen this working on new generation operating system. Still it's worth a try. There is a Microsoft way of manually rebuilding the Performance Counter, please refer the KB300956.

Then there are situation where the desired registry key itself is missing. Such cases we have to find what key is missing then manually create it. The best and easiest way. There is a small application I found someone posted in MSDN forums that will tell you which key we need to create. You can download it from here - this console application is developed by  Rafael Candido I think so. Now before we proceed further we need to create a backup of your registry.

Once you have the key we need to go toregistry and create the new key.

The best way to do this is just export the key alone (In my case 009) then save it to the Desktop as PCFix.reg. Right click on the PCFix.reg and click on Edit. Then change 009 with the value you got on the console. Then save it and close it. Just double click on the key to take effect. Once you have done just restart the computer to take effect.

To conclude one of these steps should be able to resolve the problem that you are facing with Performance counter registry hive consistency check when installing SQL Server.

I hope you find this article helpful.

How to reverse Mouse and Touchpads scrolling direction in Windows 10
Mouse and Touchpads not only make computing easy but more efficient and less time-consuming. We cannot imagine a life without these devices, but still...
How to change Mouse pointer and cursor size, color & scheme on Windows 10
The mouse pointer and cursor in Windows 10 are very important aspects of the operating system. This can be said for other operating systems as well, s...
Motoare de jocuri gratuite și open source pentru dezvoltarea jocurilor Linux
Acest articol va acoperi o listă de motoare de jocuri gratuite și open source care pot fi utilizate pentru dezvoltarea jocurilor 2D și 3D pe Linux. Ex...