| 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 |
| = azure-sqldw-latest |
[!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
DBCC SHOWRESULTCACHESPACEUSED [;] Note
[!INCLUDEsynapse-analytics-od-unsupported-syntax]
The DBCC SHOWRESULTCACHESPACEUSED command doesn't take any parameters and returns the space used by the database where the command is run.
Requires VIEW SERVER STATE permission.
| 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. |
