Microsoft SQL 2008 Setup: Performance Counter Registry Hive consistency check failed

If you experience this error on a non English or MUI version of Windows Server 2008 this Registry entry helped me to resolve the issue. It adjusts the Performance counter registry values as described in Microsoft’s KB 300956 (http://support.microsoft.com/kb/300956).

IMPORTANT: Before importing the key, make sure to Export your current Perflib settings stored here:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

Download the Registry Key here: Perflib.zip

SQL2008Perflib

I added a compiled version of Max’s C# code to retrieve the LCID.

  GetLCID (5.0 KiB, 7,189 hits)

35 responses to Microsoft SQL 2008 Setup: Performance Counter Registry Hive consistency check failed

Thanks to you i get solved this freaking problem.
I create a simple .net program console just to write the line :
string.Format(“{0,3}”, CultureInfo.InstalledUICulture.Parent.LCID.ToString(“X”)).Replace(” “, “0”);

It will output a number then download the file Perflib.zip and change the number of the Perflib key inside. Import the key and problem solved!

Hello Martijn, can you post or send me the output of “servermanagercmd -query c:\test.xml”, or let me know what roles you have installed on this system?

Hello Guys,
May be it somebody helps.
It’s neccessary to create a simple console application. Go to Visual Studio click File -> Visual C# -> Windows -> Console application.
Paste this code:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Globalization;

namespace ConsoleApplication2
{
class Program
{
static void Main(string[] args)
{
string st=string.Format(“{0,3}”, CultureInfo.InstalledUICulture.Parent.LCID.ToString(“X”)).Replace(” “, “0”);
System.Console.WriteLine(st);
System.Console.ReadLine();
}
}
}

and run (F5). You will see LCID number. Remember it.

Then download Perlib.zip. Unpack. Edit Perflib.reg in this line
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\XXX]
instead XXX enter your LCID number (for example 019) that you saw in the simple program.

Click Perflib.reg -> OK. Re-run your SQL Server installation.
That’s all.

Thanks to Max.

Great, googled a lot about this, but just adding the REG helped it!
It seems to be related to having not english-OS, but whatever – it works! Thanks alot!

Yauheni’s code, together with the perfilb.zip fixed my installation problems on a win7 enterprise 64bit dutch(NL) o.s.
Thanks!

windows XP SP3.
hello everyone. this is of course a tricky problem but the solution is very simple just change all the values in :
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib09\last counter
and
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\help.

just download the file provided at the top of this page and run it “Perflib.zip”.

if it replace all values under the above path, then its good if it creates another folder then copy all the values from the new folder to the above path

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\new folder\last counter and

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\new folder\help

replace the values and re-run the setup.
i hope it will work.

Why was this so hard and why it it not possible to find this in every forum as a great soluion!!

Thanks for the help!!

Hi there, I just had to copy the following registry entries “Counter” and “Help” and it worked for me!

What I’ve done is made a small patch for doing this programmatically.

I’ve included the sourcefiles too as someone might improve the patch.

http://www.uploadarchief.net/files/download/sql2008r2_patch.zip

Some improvements might be getting all the keys from the 009 registry, as for now only the Counter and Help key are being copied!

Still use patches like these at your own risk! Make a backup of your Registry with the System Restore program!! I’m in no way responsible for f**king up you registry, check the sources if you don’t trust them and do a rebuild!

Best regards..

FINNNALY works, I lloedk everyone for the solution on a non English Windows 2008 version with this problem with installing SQL 2008. Cant Believe MS doesnt have it in there forums.

D-Force, thanks a ton. I tried different suggestion. But none of them worked. I don’t know what I would do if I didn’t find you patch. Thanks, again.

hi,
i am working on the SQL installation and i too had the same problum with the installation can u plz guide me how to resolve the prob with the performence counter registry fail

Hello everyone,
I had win server 2003 Standard Edition SP1 ( french version),I updated the OS on SP2. After updated, I install Sql Server 2008 (english version), at the end of the installation,I got a message said that ‘ Performance Counter Registry Hive consistency check’ failed.I can’t continue installing my sql.
Can you solve me this probleme
Thank you

I cant resolve this fuuuuuuucking problem, im just tired, somebody can help me.
Im use windows 7 and I cant install sqlserver 2008 r2.
Im try and try and try, but nothing fix the problem. I need this program for the school.

sorry for my bad english, habló español
thank you…for your help.

Try to skip this check by command line like:

d:\Disrtib\SQL2008R2>SQLEXPRWT_x64_ENU.exe /ACTION=install /SKIPRULES=PerfMonCounterNotCorruptedCheck

@D-Force

The little executable by DForce is genius. I tried Micro$oft’s solution and a variety of other registry messing about for several hours. This was the fix. Use the run as administor option.

Installing SQL 2008 R2 on my Win 7 x64 PC has been a nightmare for me. After looking at Microsoft’s unbelievably complicated fix I was relieved to find this blog post. Unfortunately I was unable to download perflib.zip or GetLCID getting an error that neither file existed. I contacted @microtom, and he fixed a problem with the web site’s FQDN so I was able to download both files this morning.

The next big hurdle was being completely unable to modify the Perflib registry subkeys. I could back them up but I couldn’t see them or make any changes in Regedit including taking ownership. Even after trying psexec as suggested on another web page I found nothing worked.

I finally found my unbelievable simple answer when I stumbled upon

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/a92b4fa5-6d30-4a55-ad06-b5c4ba0abea7/performance-counter-registry-hive-consistency-error-installng-sql-2008-on-windows-7?forum=sqlsetupandupgrade

All I had to do was run setup.exe with the arguments below and abbra cadabra! It installed.

setup .exe /ACTION=install /SKIPRULES=PerfMonCounterNotCorruptedCheck

Well not really abbra cadabra because then it did give me an error about SQL 2005 Express being installed when it wasn’t in the Programs list in Control Panel, but I found the answer for that (deleting a registry key!). After that it was smooth sailing.

Every step helped get me to the right answer so thanks for posting this.

Leave a Reply