dbcc-showresultcachespaceused-transact-sql.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	dev_langs	monikerRange
DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)	DBCC SHOWRESULTCACHESPACEUSED shows the storage space used result set caching for an Azure Synapse Analytics database.	mstehrani	emtehran	wiassaf, randolphwest	12/05/2022	sql	data-warehouse	reference	TSQL	= azure-sqldw-latest

DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)

[!INCLUDE asa]

Shows the storage space used result set caching for an [!INCLUDEssazuresynapse-md] database.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

DBCC SHOWRESULTCACHESPACEUSED
[;]

Note

[!INCLUDEsynapse-analytics-od-unsupported-syntax]

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)