24
Oct/09
8

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, 210 hits)

Print This Post
(1 votes, average: 4.00 out of 5)
Loading ... Loading ...
3,109 views
Comments (8) Trackbacks (0)
  1. the same error still occurred after updatd the perflib.

  2. Hi Benny, did you get this resolved?

  3. 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!

  4. Doesn’t work for me, still have the same problem :S

    • 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?

  5. Did you receive my xml output Microtom?

  6. 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.

Leave a comment


No trackbacks yet.