PRB: DBCC SQLPERF(LOGSPACE) Limited by sp_configure Parameters

ID: Q133129

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0

SYMPTOMS

The command DBCC SQLPERF(LOGSPACE) returns the percentage of log space used in all databases up to the number of databases configured with the system procedure sp_configure 'open databases'. If you have more databases than those that are configured with sp_configure, then zeros or garbage characters are returned after 'open databases'.

CAUSE

A single query can obtain data from no more databases than the configured value for 'open databases'.

WORKAROUND

Reconfigure 'open databases' to a higher value and restart the SQL Server.

Additional query words: sql6 Windows NT logspace


Keywords          : kbusage SSrvStProc SSrvWinNT 
Version           : 4.2 4.2x 6.0
Platform          : WINDOWS 
Issue type        : kbprb

Last Reviewed: April 21, 1999