PRB: Page Faults when Performance Monitor Counters Enabled (158761)
The information in this article applies to:
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
| Modification Type: | Minor | Last Reviewed: | 2/22/2005 |
|---|
| Keywords: | kbBug kbprb kbsetup KB158761 |
|---|
|