FIX: Error "Performance Monitor Counter Requirement" when installing SQL 2005 Express

[Rock]

You'd face this error commonly when installing MSSQL 2005 Server, mostly in Express edition installations : "Performance Monitor Counter Requirement (Error)"

Here's a brief information on the error :

Setup Configuration Checker (SCC) in Microsoft SQL Server Setup verifies the value of the counter registry key before SQL Server installation begins. It scans the computer where Microsoft SQL Server 2005 will be installed. The SCC checks for conditions that prevent a successful SQL Server installation. Before Setup starts the SQL Server 2005 Installation Wizard, the SCC retrieves the status of each check item, compares the result with required conditions, and provides guidance for removal of blocking issues. All of the SCC check items are network enabled; checks can run on a local computer, as well as in remote and cluster situations.

If SCC cannot verify the existing registry key, or if it can't run the lodctr.exe system program, then the SCC check will fail, and Setup will be blocked from proceeding further.

Follow these steps to manually set the increment for the counter registry key & to overcome this error & proceed further with the SQL Server installation :

1. On the Microsoft Windows 2003 or Windows XP desktop, click Start, click Run, type regedit.exe in Open, and then click OK. On Windows 2000, use regedt32.exe The Registry Editor appliction launches.

2.Navigate to the following registry key:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]
"Last Counter"=dword:00000ed4 (5276)
"LastHelp"=dword:00000ed5 (5277)

3. The "Last Counter" value from the previous step (5276) must match the maximum value of the "Counter" key from "Perflib\009" in the following registry key,
and the "Last Help" value from the previous step (5277) must match the maximum value of the "Help" key from "Perflib\009" in the following registry key:

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

Note : The "Last Counter" and "Last Help" values are dynamically assigned by Windows; they will vary from machine to machine...

4. If necessary, modify the value for the "Last Counter" and "Last Help" values in the "\Perflib" key: Right-click "Last Counter" or "Last Help" in the right-hand pane, click Modify, click Base = "Decimal" set the value in Value data, and then click OK. Repeat for the other key, if necessary, and then close the Registry Editor.

5. Restart the machine for the changes to come into effect.

6. Run SQL Server Setup again, this time it won't fail

[eUK-Martin]

This is great stuff Rock.

I don't think that any one has realized the reason to post this fix here. We have searched many forums on Google without any solution to the error. We are one of few who has them.

If you search with "Performance Monitor Counter Requirement" you will find this thread to be the first one with a solution (Just below Microsoft without a solution).

[normanfung]

How to determine max value? max counter and max help?

How to determine max value? max counter and max help? There's a long string of numbers under Perflib\009

Many Thanks!

[Rock]

How to determine max value? max counter and max help? There's a long string of numbers under Perflib\009

Many Thanks!

There are no such values under standard server configurations. I've checked this on several machines running all versions of Microsoft Windows 2003. Are you using any other one in particular?

[tjdarth]

I actuall had this happen after I had upgraded my Web Platform Installer version:2.0 while attempting to download & install SQL Server 2008 Express SP1 on my XP Pro SP3 system

I want to make sure I understand what you are saying. I have included a zip file of the values from my \preflib\009 Hive: Which one of the values should I consider to be the maximum value?

If the Last Value for this counter is here please identify and let us know what the correct value (if any) it should be in order to help fix this problem.

thanks in advance . . .

TomJ . .

[Rock]

I actuall had this happen after I had upgraded my Web Platform Installer version:2.0 while attempting to download & install SQL Server 2008 Express SP1 on my XP Pro SP3 system

I want to make sure I understand what you are saying. I have included a zip file of the values from my \preflib\009 Hive: Which one of the values should I consider to be the maximum value?

If the Last Value for this counter is here please identify and let us know what the correct value (if any) it should be in order to help fix this problem.

thanks in advance . . .

TomJ . .

Hi Tom,

Could you ensure that you're checking the values in the correct registry path?
ie: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib]


If your 009 key is empty, follow these steps:

Changing the value of: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Counter]

to: 5276 decimal (hex 0x0000149c)

Changing the value of: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib\Last Help]

to: 5277 decimal (hex 0x0000149d)

Let me know if that helps, good luck..

[tjdarth]

Thanks Rock for the quick response. After finding MY missplaced glasses last nite, I went back and indeed found the 'Last Counter/Last Help' values under \preflib as you originally stated. Ichanged both values to '1846/1847' respectively. I also went on a little snoopying venture and found that 'Web Platform Installer' installed a new instance of SQLEXPRESS from the SQL Server 2008 EXPRESS SP1 appl, instead of updateing my existent SQLExpress2008! Now I need to find a way to correct that problem and see if I can still have access my SQL Databases.

Thanks again for all of your help!!

TomJ . . .

[Rock]

Thanks Rock for the quick response. After finding MY missplaced glasses last nite, I went back and indeed found the 'Last Counter/Last Help' values under \preflib as you originally stated. Ichanged both values to '1846/1847' respectively. I also went on a little snoopying venture and found that 'Web Platform Installer' installed a new instance of SQLEXPRESS from the SQL Server 2008 EXPRESS SP1 appl, instead of updateing my existent SQLExpress2008! Now I need to find a way to correct that problem and see if I can still have access my SQL Databases.

Thanks again for all of your help!!

TomJ . . .

You're most welcome, Tom Glad that your issue has been sorted out..

The recent MS baby; 'web platform installer' is indeed a pain in the neck, leaving the installer annoyed & out of choices Good luck..

[Spencer]

You rock!!

This post has helped me in my last breath of finishing my project. Thanks a lot ROCK!!

[Rock]

This post has helped me in my last breath of finishing my project. Thanks a lot ROCK!!

You're welcome, Spencer I'm glad this thread has helped many

It's always been a pleasure sharing ideas for me, which I'll continue to do so in the time to come.. Good luck

[dnayak]

This rocks.

I was stuck for many days, till I found this thread.

Life saver.

[Rock]

This rocks.

I was stuck for many days, till I found this thread.

Life saver.

You're most welcome

[jonny_sig]

Please help!

Hello comunnity. I want to install Windows SQL Server 2008 but i canīt because of the error describe in this thread.

I have do the solutions but the error continues when i try to install.

What is the problem?


"PerfMonCounterNotCorruptedCheck

Checks if existing performance counter registry hive is consistent."


Thanks.

Sorry about my english.

[Rock]

Hello comunnity. I want to install Windows SQL Server 2008 but i canīt because of the error describe in this thread.

I have do the solutions but the error continues when i try to install.

What is the problem?


"PerfMonCounterNotCorruptedCheck

Checks if existing performance counter registry hive is consistent."


Thanks.

Sorry about my english.

Hi,

Did you try running this command on the machine you want to install the SQL server on?

lodctr /R:PerfStringBackup.INI

Please try that & let us know if the problem persists..

[jonny_sig]

Yes i try.

But the error still there. :S


Thanks