Display the total size of the data warehouse including snapshots/restore points and geo-backups
Display the total size of the data warehouse including snapshots/restore points and geo-backups. This will help customer project storage costs of the data warehouse.
Cristhian Neumann commented
What is the ETA for this feature? This is a must have! If total size is a billing driver, we need a way to monitor it directly from Azure Portal.
Greg Galloway commented
Interestingly the "Database Size Percentage" metric in the portal appears to be accurate.
Stuart Anderson commented
Hi, I have the same issue where a 25GB (as per PDW_SHOWSPACEUSED) columnstore table is showing as a 529MB database in the portal. My table is very sparse and given that the table is also 25GB on my on-prem SQL 2012 instance shouldn't I expect the DW columnstore compression to make it much smaller than this? Is it the portal that is actually correct rather than the DBCC?
Jaladhi Mehta commented
We have a similar issue where our DB is about 800 GB but the portal shows "total database size" as 15 GB.