15 March 2012
I recently had to install SQL Server 2008 R2 Express on my local machine because Arvixe nolonger supports SQL Server 2005 anymore, but for some reason the installation was failed due to Performance Counter Registry Hive Consistency error. I managed to find the solution from the following Microsoft KB article. The article basicly tells us that the performance counter libraries are corrupted and need to be rebuilt.
How to build the base performance counters manually?
Performance counter information is stored in the following registry subkey:
- HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib
- HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\Current Version\Perflib\009
And to manually build the base performance counter libraries, please follow the following steps:
- Rename perfc009.da_ and perfh009.da_ files from your Windows Installation Disc (they're located in i386 folder) to Perfc009.dat and Perfh009.dat
- Copy and Paste them on to %Systemroot%\System32 folder
- Start Registry Editor, go to Windows > Run > Regedit > click OK
- Locate the following key in the registry HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib
- Click File > Import > Insert the following registry key perflib.zip (274.37 kb)
About Site by Tommy
Freelance web design and developer in Jakarta and Microsoft Certified Professional with five years of experience in web design and development, application development, database system, Search Engine Optimization (SEO), graphic design, logo design, business cards, corporate letterhead, posters/banners, brochures and flyers, social media marketing, and email marketing/campaign.