PRB: DBCC SQLPERF(LOGSPACE) Limited by sp_configure Parameters

Q133129

The information in this article applies to:

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


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