## PRB: SQL Performance Monitor Fails to Catch Statistics

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
Issue type :
Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2

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