BUG: Perfmon Terminates While Monitoring SQL Procedure Cache
Symptoms
If you shut down SQL Server while you are monitoring any SQL Server -Procedure Cache counter in Performance Monitor (Perfmon.exe), Perfmon.exeand Winlogon.exe close with a Divide By Zero Exception error. If you runPerfmon.exe on the Windows NT console, an Unhandled Exception error inSQLCTR60.DLL appears in Perfmon.exe.
If you monitor the counter in Perfmon.exe from a client computer, theException error occurs in Winlogon.exe and a STOP: 0xc000021a (Fatal SystemError) screen appears.
In addition, the following Application event appears in Event Viewer:
Event ID: 8Source:SQLCTR60.DLLDescription: DB-LIBRARY error: Attempt to bind to a non-existent column.
Resolution
To work around this problem:Do not monitor SQL Server – Procedure Cache counters when you shut down SQL Server.
-or-Use “On Demand Mode” for SQL Server Perfmon Integration. For moreinformation, see the “Integration with Windows NT Performance Monitor”section in the SQL Server Administrator’s Companion guide.

Leave a Reply