Sql DW storage usage

Question

Is there a straightforward way to find the storage usage of Dedicated SQL Pools (formerly SQL DW) when they have been paused (possibly for quite some time)?

I'm currently using Get-AzMetric/Azure Monitor REST API and I get results for many pools but not all. I'm wondering if no metrics get created when the service is paused and, if it remains paused for longer than the max metric retention period, I just get nothing (an empty timeseries).
If the service is paused I can't run any T-SQL queries like DBCC PDW_SHOWSPACEUSED or select from sys.dm_pdw_nodes_db_file_space_usage.

Storage is still billed so must be getting tracked somewhere, the question is where and do I have access to see it?

Answer 1

Hi @Anonymous ,

I followed with Product team internally and got update on this. Below is response. Kindly check it.

There is no direct way to extract Storage usage information when Dedicated SQL Pool is paused. As storage in Dedicated SQL Pool is managed by the SQL engine, you need to resume the DW to extract the storage usage information from the DMVs. Also, if customer is planning to pause the Dedicated SQL pool for a longer duration, they can scale it down to lower DWUs so that in future if they want to extract the usage information, it will be resumed in lower DWUs.

Hope this will help. Please let us know if any further queries.

---------------

Please consider hitting Accept Answer button. Accepted answers helps community as well. Thank you.