The problem of installing sql 2008 in win server 2008 is


The following is a general solution, and the registry and xp in the actual installation of win server2008 are different. The solution is as follows. Is the same

In this case, you must create the key in 009 as it is in 0804, and then set the last counter and lats help in perflib as follows It’s OK.

When installing SQL SERVER 2008 Developer and Enterprise Editions in Windows Server 2003, Windows XP, or Windows 2000, you will encounter "performance counter registry hive consistency" check Failed problem (Windows Server 2008 has not been tested due to temporary environment)

(Figure 1)

Installation prompt error message is: < Br>

(Figure 2)


First, according to the help prompt, open, The help document is to let you use the installation CD to reset the performance counter file. The operation steps are more complicated, but I have not installed any special software, and I have determined that there is no virus infection. Why is the performance counter damaged? Therefore, it is decided that it is not necessary. Do not reset the performance counters to avoid increasing the impact of the problem. (Microsoft's Help documentation is often unanswered....)

Sure enough, after reading the document, I found that the counter configuration information is saved in the registry


in Microsoft\\Windows NT\\CurrentVersion\\Perflib] Steps:

1. On the Microsoft Windows 2003 or Windows XP desktop, click “Start”,“Run&rdquo ;, then type regedit.exe in "open" and click “OK”. In Windows 2000, start the Registry Editor with regedt32.exe

2. Locate the following registry key:

[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT \\CurrentVersion\\Perflib]

"Last Counter"=dword:0000566a(22122) (This value varies depending on the machine, not a fixed value) "Last Help"=dword:0000566b(22123) (This value varies from machine to machine, not a fixed value.)

(Figure 3)

In Figure 3 we see that there are two sub-perflibs. Project

[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib\\004]

[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib\\009]

After comparison, it is found that the maximum value of the counters existing under the two subfolder items is different

(Fig. 4) The maximum value of the Counter item in Perflib\\004 is 22178 (this value varies according to Machines are different, not fixed values)

(Figure 5) Help project in Perflib\\004 The maximum value is 22179 (this value varies according to different machines, not a fixed value)

(Figure 6) The maximum of the Counter project in Perflib\\009 The value is 22122 (this value varies according to different machines, not a fixed value)

(Figure 7) The maximum value of the Help item in Perflib\\009 is 22123 (This value varies depending on the machine, not a fixed value)

Obviously, as shown, on my machine [HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT \\CurrentVersion\\Perflib]

"Last Counter" and "Last Help" values, and the maximum saved in [HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib\\009] The values ​​are the same, 22122 and 22123 respectively (these two values ​​are different for each computer), and the maximum value saved in [HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib\\004] is different. Due to this difference, the performance counter registration was encountered during SQL Server 2008 installation. Hive Consistency & rdquo; check failure fault.

Cause Analysis:

Because the Visual Studio 2005 Express language version included in the English version of Visual Studio 2008 was installed in English, it was tested and installed. SQL SERVER 2005 Developer Edition simplified Chinese development version, and then uninstalled SQL SERVER 2005 Developer Edition simplified Chinese development version, intends to install SQL SERVER 2008 Developer Edition Simplified Chinese Development Office, due to language inconsistency and repeated installation and uninstallation, estimated Is the installation program error when uninstalling, causing the inconsistency of key values ​​in the registry

Problem solving:

Knowing the cause of the fault, the problem is very Well solved, since we are using the Simplified Chinese version of the operating system, so be sure to

[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib] "Last Counter" and "Last Help" The values ​​of these two are the most saved in the

[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib\\004]"Counter" and "Help" The value is the same

If we are using the English version of the operating system, then be sure to

[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib] "Last Counter" ; and the values ​​of "Last Help" are the same as the maximum values ​​saved in

[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib\\009]

(Figure 8)

Modify the value of "Last Counter" in [HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib] to make it and [HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\ The maximum value of "Counter" in Windows NT\\CurrentVersion\\Perflib\\004] is the same, we are here to change to 22178

(Figure 9)

Modify the value of "Last Help" in [HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib] to make it "[HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\Windows NT\\CurrentVersion\\Perflib\\004] The maximum value of Help" is the same, we are here to change to 22179

Note that when modifying numbers, you must select the base number to be “decimal" (the default is hexadecimal), otherwise the numbers will not match and the SQL SERVER 2008 installer check will fail again.

(Note: There are certain risks in modifying the registry, which may cause damage to your system. Please back up the registry in case you need to recover after a problem occurs. Please refer to Microsoft Knowledge for how to back up and restore the registry. The corresponding topic in the library: [322756] How to backup and restore the Windows registry)

Test effect:

Then close the registry editor and start installing SQL SERVER again 2008 Developer Edition Simplified Chinese Development Edition

(Figure 10) Test passed, no more errors, can be installed normally

At this point, the problem Completely solved, and the solution is simply to modify the two registry keys.


It can be seen that in the case of problems, if you don't think about it, you can completely copy the help documentation, which may take half the effort and cause a lot of unnecessary trouble, because the help documentation is only It gives us a general direction, and the person writing the help documentation is not likely to know the actual environment in which we have problems, so the help documentation is very useful as a reference, but when it comes to problems, our practical experience and hands-on testing Ability is also very important, so that you can take fewer detours.

Copyright © Windows knowledge All Rights Reserved