dbcc-showresultcachespaceused-transact-sql.md

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