Article ID: 839506
Article Last Modified on 10/30/2006
APPLIES TO
- Microsoft Windows Server 2003, Web Edition
- Microsoft Windows Server 2003, Standard Edition (32-bit x86)
- Microsoft Windows Server 2003, Enterprise Edition (32-bit x86)
- Microsoft Windows Server 2003, Datacenter Edition (32-bit x86)
- Microsoft Windows Server 2003, Enterprise x64 Edition
- Microsoft Windows Server 2003, 64-Bit Datacenter Edition
SYMPTOMS
After you save SQL performance counters as a counter log file (a .blg file) in Microsoft Windows Server 2003 System Monitor and then open the counter log file in System Monitor, no SQL performance counters appear. An event message that is similar to the following is logged in the system event log for each SQL performance counter that was not saved in the counter log file:
Event Type: Warning
Event Source: SysmonLog
Event Category: None
Event ID: 2028
Date: 3/2/2004
Time: 6:58:28 AM
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://support.microsoft.com.
Note In this event message, ComputerName
is a placeholder for the actual computer name, and CounterName
is a placeholder for the actual counter name.
CAUSE
This problem occurs because, by default, the Performance Logs and Alerts service runs under the Network Service account in Windows Server 2003, but the Network Service account may not have permissions to save the SQL performance counters in a trace file.
RESOLUTION
To resolve this problem, change the Performance Logs and Alerts service account to use the Local System account. To do this, follow these steps:
- Click Start, point to Programs, click Administrative Tools, and then click Services.
- In Services, right-click Performance Logs and Alerts, and then click Properties.
- In the Performance Logs and Alerts Properties Service (Local Computer) dialog box, click the Log On tab.
- Click Local System account under Log on as, and then click OK.
MORE INFORMATION
This problem typically affects only SQL Server performance counters. This problem does not occur with system performance counters such as the following:
- Memory
- Network Interface
- Paging File
- PhysicalDisk
- Process
- Processor
- Thread
Keywords: kbprb KB839506