SQL Server Development Bookmark and Share   
 index > SQL Server Setup & Upgrade > error on install: Performance counter registry hive consistency check - Status:Failed
 

error on install: Performance counter registry hive consistency check - Status:Failed

Hi, I'm tryng to install sql server 2008 in win vista and in the System Configuration Check, item: Performance counter registry hive consistency check has the status FAILED all the others items has PASSED and the setup stops here theonly option is CANCEL. Thus anyone knows the possible problem and resolution to this?

best regards

Evok-pt  Wednesday, April 09, 2008 11:56 PM
If your windows is not pt-BR, you probably won't. I created this stuff to help:
http://www.2shared.com/file/3276145/d5475cc1/Chave_do_registro_SQL_2008.html

This shows the registry key you'll have to create at your computer.
Rafael Candido  Monday, May 12, 2008 11:44 AM

There is another post discussing the same issue as yours. The subject of post is:

How to resolve "Performance counter registry hive consistency check" failed?

Please refer that post and see if it resolves the issue. The bottom line is that you need to rebuild the perfmon counter, correct the bad registry key hive, and then you can install SQL Server 2008.

If the reference of post doesn’t resolve the problem, please use “regedit.exe�to export the following registry key hive to a file, and then post the file here.

“HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib�/font>

Once I get the file, I will try to rebuild the perfmon counter for you.

The tool “regedit.exe�usually exports registry keys to files with extension �reg� If you post the file, please rename it to the extension �txt�so that it can reach to the forum.

Thanks.

Yuhong

Yuhong Li - MSFT  Monday, April 21, 2008 5:55 PM
Dude, put this at any Console application:
string.Format("{0,3}", CultureInfo.InstalledUICulture.Parent.LCID.ToString("X")).Replace(" ", "0");

Watch the result. At mine it was "016".

Then you go to the registry at this key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

and create another one with the name you got from the string.Format result. In my case:
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\016"

and copy the info that is on any other key in this Perflib to this key you just created. Run the instalation again. Done!
Rafael Candido  Thursday, April 24, 2008 1:32 PM

i've got the same problem. but how to get the result like "016" of yours at mine?

bentc  Saturday, May 10, 2008 5:27 PM
If your windows is not pt-BR, you probably won't. I created this stuff to help:
http://www.2shared.com/file/3276145/d5475cc1/Chave_do_registro_SQL_2008.html

This shows the registry key you'll have to create at your computer.
Rafael Candido  Monday, May 12, 2008 11:44 AM
Hi Rafael!

Your application and your tips were very useful for me when installing SQLServer2008 on Vista Business.
Thank you!


Regards,

Jeferson Oliveira
Brazil
Jeferson Oliveira  Tuesday, May 13, 2008 2:14 AM
Thanks Rafael,

This worked for me.

Rhino  Sunday, November 16, 2008 4:45 PM

Rafael, brilliant work. http://support.microsoft.com/kb/300956was worthless, adding the key you mention with the same values as the other worked in seconds.

thank you.

gabegabe  Friday, November 28, 2008 10:21 AM

This issue can be easily fixed by type the following command in Command Prompt window.

lodctr /R:PerfStringBackup.INI



(this works on Xp)

  • Proposed As Answer byolrt Saturday, June 20, 2009 7:49 AM
  •  
Panneer_2009  Thursday, April 30, 2009 4:29 PM
Dude, put this at any Console application:
string.Format("{0,3}", CultureInfo.InstalledUICulture.Parent.LCID.ToString("X")).Replace(" ", "0");

Watch the result. At mine it was "016".

Then you go to the registry at this key:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib

and create another one with the name you got from the string.Format result. In my case:
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\016"

and copy the info that is on any other key in this Perflib to this key you just created. Run the instalation again. Done!

Hey, nothing was working. The Technet link is useless. But this worked like a charm. Thanks!
Carlos Sosa Albert  Monday, May 04, 2009 3:31 PM

This issue can be easily fixed by type the following command in Command Prompt window.

lodctr /R:PerfStringBackup.INI



(this works on Xp)


Mate not only was this by FAR the easiest thing to do on XP for a novice user, it worked straight away. Lifesaver! If you're running XP i would use this solution
docj84  Tuesday, May 26, 2009 8:53 AM
I would have been reduced to tears with the failed 2008 installation attempts, save for your brilliant solution...now with any luck,I can actually get jobs (all) that, whether they use it or not,demand SSAS!!! (as long as they don't look up AdventureWorks on the web...) thanks so much
8^) DOS to the rescue...
billygibbs  Friday, May 29, 2009 7:27 PM

This issue can be easily fixed by type the following command in Command Prompt window.

lodctr /R:PerfStringBackup.INI



(this works on Xp)


I confirm that
1°) the KB300956 article was worthless.
2°) the above command solves the problem.
olrt  Saturday, June 20, 2009 7:52 AM

yes, it works on my xp also

Nepho  Thursday, July 09, 2009 10:25 AM
This resolved my issue in 32 bit Vista as well. seems it should be added to the Knowledge base article.
Greg Mitchell  Tuesday, September 22, 2009 12:10 PM
Hi Rafael,

I've installed Windows 7 Ultimate PT-BRwith english language pack. I tried to install SQL Server 2008 Express 64 bits and got the same error "Performance counter registry hive consistency check failed"

Did the changes you suggested in registry but couldn't install it until I created a key with the locale ID for pt-br "0416" and copied all the valuesthat were inside the key "009" into it.

I found the locale ID for pt-br inthis page http://msdn.microsoft.com/en-us/goglobal/bb964664.aspx

Hope this could help anyone experiencing the same problem.
PMaculan  Tuesday, November 03, 2009 1:10 AM

You can use google to search for other answers

Custom Search

More Threads

• SQL Server 2008 & .Net 3.5 Installation failure
• Error - Installing SQL Server 2005 Client Tools
• Unable to install default instance of SQL Server 2008 Express
• monitoring the error log file
• kB 970892
• Error on Katmai SQL 2008
• SQL 2008 Cluster: WMI service preinstallation check fails
• Setup of SQL Server 2008: Restart required but I have restarted
• MS SQL Server 2005 update Advisor Report - "item has already been added" "key in dictionary"
• SP1 CU4 - KB 973602 - Microsoft.SqlServer.SapBiComponents.dll update not included?