Microsoft KB Archive/133129

{|
 * width="100%"|

PRB: DBCC SQLPERF(LOGSPACE) Limited by sp_configure Parameters

 * }

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

Issue type : kbprb

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600 kbSQLServ420OS2