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