DBCC SHOWRESULTCACHESPACEUSED (Transact-SQL)
Applies to: Azure Synapse Analytics
Shows the storage space used result set caching for an Azure Synapse Analytics database.
Transact-SQL syntax conventions
Syntax
DBCC SHOWRESULTCACHESPACEUSED
[;]
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
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
Tilbakemeldinger
https://aka.ms/ContentUserFeedback.
Kommer snart: Gjennom 2024 faser vi ut GitHub Issues som tilbakemeldingsmekanisme for innhold, og erstatter det med et nytt system for tilbakemeldinger. Hvis du vil ha mer informasjon, kan du se:Send inn og vis tilbakemelding for