SQL Server Installation Failure due to Corruption in Performance Counter

Today when doing SQL Server Installation, I have got the following error. This is because the performance counter registry hive has got corrupted.

By looking at the error we have found that the issue is with the performance counter,  During the SQL Server installation it is trying to check the performance counter registry’s consistency, since the registry hive is corrupted  it is unable to do any of the operation and it is getting failed.

How to fix this now? is our next question, I referred this KB Article which was there in the error message and performed the following steps

In the above steps I have taken the backup of the current registry string and rebuilt the performance registry based on the current registry settings in backup INI files.

Once it is done I just clicked on Rerun button as shown below, and found the operation got completed and gave me a path to go for the next step and finally the installation got completed successfully!!

Here are the information about the other commands which I came across when I was working on this, Hope it will be useful.

LODCTR-It Updates registry values related to performance counters.

Hint-If incase any arguments with spaces is used in the names then the name must be enclosed within double quotation marks.

Different Parameters Usuage:

LODCTR <INI-FileName>

INI-FileName is the name of the initialization file that contains the counter name definitions and explain text for an extensible counter DLL.

LODCTR /S:<Backup_File_Name>

The above command saves the current perf registry strings and info to <Backup_File_Name>

LODCTR /R:<Backup_File_Name>

The above command restores the perf registry strings and info using <Backup_File_Name>

LODCTR /R

The above command rebuild the perf registry strings and info from scratch based on the current registry settings and backup INI files.

LODCTR /D:<Service_Name>

The above command disables the performance counter service.

LODCTR /Q

LODCTR /Q:<Service_Name>

The above command queries the performance counter service information, either query all or specified one.

LODCTR /M:<Counter_Manifest>

The above command installs Windows Vista performance counter provider definition XML file to system repository.

LODCTR /T:<Service_Name>

The above command sets the performance counter service as trusted.

LODCTR /E:<Service_Name>

The above command enables the performance counter service.