”Don’t focus on having a great blog. Focus on
producing a blog that’s great for your readers.”- Brian Clark

SQL Server 2008 Performance Counter Registry Hive Consistency Failed

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:

  1. Rename perfc009.da_ and perfh009.da_ files from your Windows Installation Disc (they're located in i386 folder) to Perfc009.dat and Perfh009.dat
  2. Copy and Paste them on to %Systemroot%\System32 folder
  3. Start Registry Editor, go to Windows > Run > Regedit > click OK
  4. Locate the following key in the registry HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Perflib
  5. Click File > Import > Insert the following registry key perflib.zip (274.37 kb)

Good luck!!

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.

Project Highlight
What Client Says
I’ve Got You Covered
  • Website Design
  • Application Development
  • Database System
  • Search Engine Optimization
  • Web Hosting
  • Graphic Design
  • Logo Design
  • Business Cards
  • Corporate Letterhead
  • Posters/Banners
  • Brochures and Flyers
  • Event Invitations
  • Promotional Products
  • Social Media Marketing
  • E-mail Marketing/Campaign
  • Event Marketing