An error occurred while checking "performance counter registry Configuration unit consistency" during SQL Server installation.

When installing SQL Server 2003 Development edition and Enterprise Edition on Windows Server 2000, Windows XP, or Windows 2008, the "performance counter registry Configuration unit consistency" check will fail (Windows Server 2008 has not been tested due to no environment currently)

(Figure 1)

The installation error message is:

(Figure 2)

Solution:

First, openHttp://support.microsoft.com/kb/300956The help document is to allow you to reset the performance counter file by using the installation disc. The operation steps are complex. However, I have not installed any special software and are sure there is no virus infection, why is the performance counter damaged? Therefore, we have no choice but to temporarily reset the performance counter to avoid increasing the impact of the problem. (Microsoft's help documentation often does not answer questions ....)

Indeed, after reading the document, we found that the counter configuration information was saved in the registry.

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

Procedure:

1. on the Microsoft Windows 2003 or Windows XP desktop, click Start and run, type regedit.exe in open, and click OK ". In Windows 2000, use regedt32.exe to start the Registry Editor.

2. Locate the following registry key:

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

"Last counter" = DWORD: 425566a (22122) (this value varies with machines, not fixed values)
"Last help" = DWORD: 566b (22123) (this value varies with machines, not fixed values)

(Figure 3)

As shown in figure 3, Perflib has two sub-projects.

[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 there are different counters under the two subfolders.

(Figure 4) in Perflib \ 004, the counter project's maximum value is 22178 (This value varies with machines, not fixed values.)

(Figure 5) the maximum value of the help project in Perflib \ 004 is 22179 (This value varies with machines, not fixed values.)

(Figure 6) in Perflib \ 22122, the maximum counter project value is (This value varies with machines, not fixed values.)

(Figure 7) the maximum value of the help project in Perflib \ 22123 is (This value varies with machines, not fixed values.)

Apparently, on my machine [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib]

The values of "Last counter" and "last help" are the same as the maximum values saved in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 009, they are 22122 and 22123 respectively (these two values are different for each computer ), the maximum value stored in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 004] is different from that in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 004, this causes the SQL Server 2008 installation to fail to check the "performance counter registry Configuration unit consistency.

Cause analysis:

The Visual Studio 2008 express language included in Visual Studio 2005 is an English version, and the SQL Server 2005 Developer Edition Simplified Chinese development version is tested and installed, after that, I uninstalled the SQL Server 2005 Developer Edition Simplified Chinese development edition and planned to install the SQL Server 2008 Developer Edition Simplified Chinese Development Office. due to language inconsistency and repeated installation and uninstallation, installation is estimatedProgramAn error occurred while uninstalling the registry, resulting in inconsistent key values in the registry.

Solution:

The cause of the fault is known, and the problem is well solved, because we useSimplified Chinese versionOperating System, so ensure

The values of "Last counter" and "last help" in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib] are

In [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 004], "counter" and "help" have the same maximum value.

If we useEnglish versionThe operating system must be guaranteed

The values of "Last counter" and "last help" in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib] are

The maximum value saved in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 009] is the same.

(Figure 8)

Modify the value of "Last counter" in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib, make it consistent with the maximum value of "counter" in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 004]. Here we change it to 22178

(Figure 9)

Modify the value of "last help" in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib, make it consistent with the maximum value of "help" in [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 004]. Here we change it to 22179

Note that,When you modify a number, you must select the base number in decimal format (the default value is hexadecimal). Otherwise, the number does not match and the SQL Server 2008 installer will fail to check the number again..

(Note: There is a certain risk of modifying the Registry, which may cause damage to your system. Please back up the registry for recovery after the problem occurs. For details about how to back up and restore the registry, refer to the topics in the Microsoft Knowledge Base:[322756] how to back up and restore the Windows Registry)

Test results:

Close the Registry Editor and Install SQL Server 2008 Developer Edition

(Figure 10) the test is passed and no error occurs. you can install the tool normally.

Now, the problem is completely solved, and the solution is simply to modify the two registry key values.

Summary:

It can be seen that when you encounter a problem, if you do not think about it, you may be able to make a lot of effort and cause a lot of unnecessary trouble, because the help document only shows us a general direction, and the person who writes the help document cannot know the actual environment of the problem we encountered. Therefore, the help document is very useful as a reference, however, in case of problems, our practical experience and hands-on testing capabilities are also very important, so that we can avoid detours.

Note:

[HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 004] and [HKEY_LOCAL_MACHINE \ SOFTWARE \ Microsoft \ Windows NT \ CurrentVersion \ Perflib \ 009] correspond to C: \ eight files under WINDOWS \ SYSTEM. If 004 and 009 cannot be edited, you can directly copy these eight files from another computer.