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