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.

Gry How to download and Play Sid Meier's Civilization VI on Linux
How to download and Play Sid Meier's Civilization VI on Linux
Introduction to the game Civilization 6 is a modern take on the classic concept introduced in the series of the Age of Empires games. The idea was fai...
Gry How to Install and Play Doom on Linux
How to Install and Play Doom on Linux
Introduction to Doom The Doom Series originated in the 90s after the release of the original Doom. It was an instant hit and from that time onwards th...
Gry Vulkan for Linux Users
Vulkan for Linux Users
With each new generation of graphics cards, we see game developers push the limits of graphical fidelity and come one step closer to photorealism. But...