April 6, 2009

Performance Counter Errors

Filed under: Server 2008 — Tags: — lpopejoy @ 7:13 pm

Ok, so I’m getting this error in my event logs now (on my SBS 2008 Server):

Log: Application

Type: Warning

Event: 2003

Agent Time: 3:17:42 am 6-Apr-09

Event Time: 7:17:42 am 6-Apr-09 UTC

Source: Microsoft-Windows-Perflib

Category: None

Username: N/A

Computer: ICS-S01.ics.local

Description: The configuration information of the performance library “C:\Windows\system32\sqlctr90.dll” for the “MSSQL$ICSAPPS” service does not match the trusted performance library information stored in the registry. The functions in this library will not be treated as trusted.

 

The fix?  Following the solution as suggested in this KB:  http://support.microsoft.com/kb/928384

 

This should be run from an elevated command prompt (right click on command prompt and click “Run as administrator”).

 

Here is what mine looked like:

 

C:\Windows\system32>unlodctr MSSQL$ICSAPPS

Removing counter names and explain text for MSSQL$ICSAPPS

Updating text for language 009
C:\Windows\system32>lodctr “C:\Program Files (x86)\Microsoft SQL Server\MSSQL.2\MSSQL\Binn\perf-ICSAPPSsqlctr.ini”