How do I fix a "Performance counter registry hive consistency" when installing SQL Server R2 Express?
Solution 1
You can skip the Performance counter check in the setup altogether:
setup.exe /ACTION=install /SKIPRULES=PerfMonCounterNotCorruptedCheck
Solution 2
Use Rafael's solution: http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/dddf0349-557b-48c7-bf82-6bd1adb5c694..
Added data from link to avoid link rot..
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.
Just run the script and get your 3 digit code. Then follow his simple and quick steps, and you're ready to go!
Cheers
Solution 3
I had this same problem. For me this solution worked for SQL Server 2008 R2 Express.
- Create a shortcut for
SQLEXPRWT_x64_ENU.exe
(This is the name of the file I used) - Right-click on the shortcut and click "Properties"
- Look for a box under the shortcut tab that says "Target"
- Inside of the target box, add to whatever is already in there this line:
/Action=install /SKIPRULES=PerfMonCounterNotCorruptedCheck
Of course this does not fix the underlying issue but it is a workaround because this fix also works on the principle of skipping the Performance counter check in the setup. The difference is this method worked for me when doing it through the command line failed.
Solution 4
I had the perf counter reg issue and here's what I did.
- My exe file was SQLManagementStudio_x86_ENU.exe
- In command line typed in the below line and hit enter
C:\Projects\Installer\SQL Server 2008 Management Studio\SQLManagementStudio_x86_ENU.exe /ACTION=install /SKIPRULES=PerfMonCounterNotCorruptedCheck
(Note : i had the exe in this location of my machine C:\Projects\Installer\SQL Server 2008 Management Studio)
- SQL Server installation started and this time it skipped the rule for Perf counter registry values. The installation was successful.
Solution 5
open Command line and type lodctr /r The p. counter will be resotred\recreated.
There is no need to skip it. http://technet.microsoft.com/en-us/library/cc774958.aspx
Angry Dan
web/software developer, .NET, C#, WPF, PHP, software trainer, English teacher, have philosophy degree, love languages, run marathons my tweets: http://www.twitter.com/edward_tanguay my runs: http://www.tanguay.info/run my code: http://www.tanguay.info/web my publications: PHP 5.3 training video (8 hours, video2brain) my projects: http://www.tanguay.info
Updated on July 09, 2022Comments
-
Angry Dan almost 2 years
I'm trying to install SQL Server 2008 R2 Express from this site:
http://www.microsoft.com/express/database/
I have a 64-bit, Windows 7 machine.
I have tried both the 32-bit and 64-bit versions but each fail on "Performance counter registry hive consistency".
How can I fix this so that I can install SQL Server 2008 R2 Express?
-
Chuck Krutsinger over 10 yearsPlease clarify "1) Folder 00A: 2) Counter: the last number 3) Help: the last number". What last number? In my case, folder 00A has a counter with no value set.
-
willll about 10 yearsIt is a C# console application
-
Nicolas Vieira almost 9 yearsThis is the solution on multiple sources, but still didn't help me. The registry edit (described terribly above, but better on other sites, also didn't work) The location wasn't the issue either. The only working solution was to use the skiprule switch.
-
Nicolai Lissau over 8 yearsJust for clarity: Everything after .exe are options. If the setup file is called e.g.
SQLEXPRWT_x64_ENU.exe
then you should run the program from the command line asSQLEXPRWT_x64_ENU.exe /ACTION=install /SKIPRULES=PerfMonCounterNotCorruptedCheck
-
Baljeetsingh almost 7 yearsAwesome find! Curious to know how did you find this ?!!
-
Baljeetsingh almost 7 yearsYou could also use Linqpad or Visual studio Code
-
mcfroob almost 7 yearsThanks! Just by browsing various Microsoft forums, comparing the registry entries from different installs and working it out. Glad it helped :)
-
chris over 4 yearsMake sure you use lodctr /R with uppercase R & retry the command from SysWOW64 directory. src: github.com/JimmyAppelt/Snaz/wiki/…