SQL2005 Performance Monitor Counter error resolution _MSSQL2005

"System Environment"

Windows 2003 +sql2005

"Problem Situation"

Users will cause SQL2005 Performance Monitor counter errors after improper deletion of SQL2005, as shown in the following figure

"Solution"

1, in the "Start"--> "Run" in the input regedit, open Registry Editor, navigate to

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

, you can see 004 and 92 subdirectories under the Perflib directory in the right tree directory.

The SQL Server 2005 installation help file says that you need to view the 009 directory registry entries, and most of us are using the Simplified Chinese operating system, so we can't say what we're saying in the help.

Instead, you need to be aware of the contents of the 004 directory.

To open the contents of the 004 directory, you can see the following figure:

We double click on "Counter" and "help" to see the final number, as shown in the following figure:

The contents of the Counter item:

Helper Item Content

At this point, we know that the number of Counter items is 5556,helper 5557.

Then, manipulate the left tree of Registry Editor, navigate to the Perflib directory, and check the values of the "Laster Counter" and "Laster help" items in the right window and turn Laster The value of the counter is changed to the counter value 5556 just recorded, and the value of Laster help is changed to the value 5557 of the help that was just noted.

Note that when you modify a number, you must select the cardinality as "decimal", or the number will not match, and the SQL Server 2005 check will fail again.

Then close Registry Editor and start installing SQL Server 2005, and you can absolutely install successfully.