Microsoft KB Archive/158761

= 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.