PRB: Page Faults when Performance Monitor Counters Enabled
Article ID: 158761
Article Last Modified on 2/22/2005
APPLIES TO
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q158761
BUG #: 16170 (6.5)
SYMPTOMS
The performance monitor object Memory, counter Page Faults/sec will not
average around 0 (zero) if the SQL Server Performance Monitor counters are
enabled in SQL Server Setup.
RESOLUTION
To work around this problem, rename the file Sqlctr60.dll in the Bin
directory where SQL Server is installed; this disables the SQL Server
Performance Monitor counters.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
version 6.5. For more information on this problem, please see the following article in the Microsoft Knowledge Base:
167044 Request From Perfmon Counter Can Cause Excessive Page Faults
Additional query words: perfmon
Keywords: kbbug kbsetup kbprb KB158761