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.