Microsoft KB Archive/122148

{|
 * width="100%"|

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