--- title: DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL) ms.custom: "" ms.date: "07/03/2019" ms.prod: sql ms.technology: data-warehouse ms.reviewer: "" ms.topic: "language-reference" dev_langs: - "TSQL" ms.assetid: 73f598cf-b02a-4dba-8d89-9fc0b55a12b8 author: XiaoyuMSFT ms.author: xiaoyul monikerRange: "= azure-sqldw-latest || = sqlallproducts-allversions" --- # DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL) [!INCLUDE[tsql-appliesto-xxxxxx-xxxx-asdw-xxx-md](../../includes/tsql-appliesto-xxxxxx-xxxx-asdw-xxx-md.md)] Shows the storage space used result set caching for an Azure [!INCLUDE[ssSDW](../../includes/sssdw-md.md)] database. ![Topic link icon](../../database-engine/configure-windows/media/topic-link.gif "Topic link icon") [Transact-SQL Syntax Conventions (Transact-SQL)](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md) ## Syntax ```syntaxsql DBCC SHOWRESULTCACHESPACEUSED [;] ``` ## 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](/azure/sql-data-warehouse/performance-tuning-result-set-caching)
[ALTER DATABASE SET Options (Transact-SQL)](/sql/t-sql/statements/alter-database-transact-sql-set-options?view=azure-sqldw-latest)
[ALTER DATABASE (Transact-SQL)](/sql/t-sql/statements/alter-database-transact-sql?view=azure-sqldw-latest)
[SET RESULT SET CACHING (Transact-SQL)](/sql/t-sql/statements/set-result-set-caching-transact-sql)
[DBCC DROPRESULTSETCACHE (Transact-SQL)](/sql/t-sql/database-console-commands/dbcc-dropresultsetcache-transact-sql)