JSI Tip 8011. The SQL performance counters are missing from the Windows Server 2003 counter log file?

When you open a .blg (counter log) file in Windows Server 2003 System Monitor, the SQL performance counters that you saved are missing.

Your System event log may contain a message, similar to the following, for each counter that was NOT saved:


Event Type: Warning 
Event Source: SysmonLog 
Event Category: None 
Event ID: 2028 
Date: MM/DD/YYYY
Time: HH:MM:SS 
User: N/A 
Computer: <ComputerName>
Description: The service was unable to add the counter '\\<ComputerName>\<CounterName>'
             to the log or alert. This log or alert will continue, but data for that counter will
             not be collected. The error returned is:
             The specified object is not found on the system. 

             For more information, see Help and Support Center at
             http://go.microsoft.com/fwlink/events.asp.

This behavior occurs because the Performance Logs and Alerts service is running in the Network Service account context, which does not have sufficient permissions to save the SQL performance counters in a trace file.

To fix this problem:

1. Start / Run / Services.msc / OK.

2. Double-click Performance Logs and Alerts.

3. Select the Log On tab.

4. Select the Local System account radial button.

5. Press Apply and OK.

Comments

Plain text