DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)

Applies to: Azure Synapse Analytics

Shows the storage space used result set caching for an Azure Synapse Analytics database.

Transact-SQL syntax conventions

Syntax

DBCC SHOWRESULTCACHESPACEUSED
[;]

Note

This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.

Remarks

The DBCC SHOWRESULTCACHESPACEUSED command doesn't take any parameters and returns the space used by the database where the command is run.

Permissions

Requires VIEW SERVER STATE permission.

Result sets

Column Data type Description
reserved_space bigint Total space used for the database, in KB. This number will change as the cached result set increases.
data_space bigint Space used for data, in KB.
index_space bigint Space used for indexes, in KB.
unused_space bigint Space that is part of the reserved space and not used, in KB.

See also