dbcc-showresultcachespaceused-transact-sql.md

description	DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)
title	DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)
ms.custom
ms.date	07/03/2019
ms.prod	sql
ms.technology	data-warehouse
ms.reviewer	wiassaf
ms.topic	language-reference
dev_langs	TSQL
author	mstehrani
ms.author	emtehran
monikerRange	= azure-sqldw-latest

DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)

[!INCLUDE asa]

Shows the storage space used result set caching for an Azure [!INCLUDEssSDW] database.

Transact-SQL Syntax Conventions (Transact-SQL)

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)