RECOMMENDED: Click here to fix Windows errors and optimize system performance
As I mentioned last week, I will discuss various SQL Server installation problems and troubleshooting tips to solve the problem. Last week we discussed how to handle SQL Server work errors stopped working and went through various steps to fix it. So this week I’m discussing another common bug you get when you troubleshoot SQL Server 2008 R2 / 2012, and that is Performance Counter Registry Hive Consistency Check Error. Let’s discuss the context of this error message.
Register counter consistency check failed
You do not need the performance counter in all cases, in some cases you can simply skip it. During installation, a set of performance counters is used to monitor the performance of the data flow engine.
According to TechNet, the best example is the spooled buffer This counter is intended to determine if data buffers are temporarily written to disk during the execution of a packet. But as I said, some applications that run with SQL don’t really need it. It is mainly used for standalone SQL on a data server that requires a lot of monitoring. So, if you want to skip the performance counter consistency check, you can start the SQL Server installation with the following switching value.
C:Downloadssetup.exe /ACTION=install /SKIPRULES=PerfMonCounterNotCorruptedCheck
Replace the directory where the installation files are located.
Reconstruction of the supply counter
If you start the configuration with this switching value, you must skip this step and continue the installation. This is one way to avoid this error message. The other option, also mentioned in Microsoft KB, is to recreate the performance counter.
- Click Start and enter CMD
- Right-click and click Run as administrator
- Then type /R:PerfStringBackup.INI and press Enter
- Restart the system and try installing SQL Server again.
But I hardly saw this work on the next generation operating system. Nevertheless, it is worth a try. There is a way to manually recreate the performance counter, see KB300956
Then there is a situation where the desired registry key is missing. In such cases, we must find the missing key and create it manually. The best and simplest. There is a little app I found in the MSDN forums that tells you what key we need to create. You can download it here – this console application was developed by Rafael Candido. Before continuing, we must make a backup of your registry.
- Click Start and enter Regedit
- Right-click and click Run as Administrator
- Go to HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib
- Right-click Perflib and click the new key
- Then enter the value you received when running the console application
- Then you can have other keys under Perflib, for example 009 etc.
- You must copy this information and place it under the newly created key
Just export the key (in my case 009) and save it on the desktop as PCFix.reg. Right-click the PCFix.reg file and click Edit. Then change 009 to the value you have on the console. Save it and close it. Simply double-click the button to activate it. Once you have done this, simply restart your computer to make it work.
To complete one of these steps, you should be able to solve the problem you are facing with the registry consistency check of the hive registry performance counter when installing SQL Server.
I hope you find this article useful.