PRB: SQL Performance Monitor Fails to Catch Statistics

ID: Q122148


The information in this article applies to:
  • Microsoft SQL Server version 4.2x


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 :


Last Reviewed: March 20, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.