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

• Performance tuning with result set caching
  
• ALTER DATABASE SET Options (Transact-SQL)
  
• ALTER DATABASE (Transact-SQL)
  
• SET RESULT SET CACHING (Transact-SQL)
  
• DBCC DROPRESULTSETCACHE (Transact-SQL)