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
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om