PRB: SQL Performance Monitor Fails to Catch Statistics

Last reviewed: April 30, 1997
Article ID: Q122148

The information in this article applies to:

  - Microsoft SQL Server version 4.2

SYMPTOMS

SQL Server Performance Monitor fails to catch any of the SQL Server performance statistics. In the Windows NT Event Viewer a series of SQLCTRS errors are reported. The errors include:

   DB-LIBRARY - SQL Server message: Invalid object name 'syslocks'.
   DB-LIBRARY - SQL Server message: Invalid object name 'sysprocesses'
   DB-LIBRARY - SQL Server message: Stored procedure 'MS_sqlctrs_users'
                not found.
   CollectSQLPerformanceData : dbsqlsend failed

CAUSE

The default database for the PROBE login has been set to a database other than MASTER. The PROBE login's default database should be set to MASTER and should not be changed.

The purpose of the PROBE login is for supporting two-phase commit processing and for gathering SQL Server performance statistics.

WORKAROUND

To resolve the problem, change the default database for the PROBE login back to the MASTER database:

   sp_defaultdb probe, master

Additional query words: Windows NT
Keywords : kbtool SSrvWinNT
Version : 4.2 4.21
Platform : WINDOWS
Issue type : kbtshoot

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: April 30, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.