Ability to view backup storage usage via Portal, Powershell, or DMV
As there is currently a $0.10/GB charge for PiTR storage over the size of the database size it will be important to have a way to view backup storage usage so you can best plan how long to have your retention set to best optimize your billing.
If possible this could be a property in Get-AzSqlDatabase and Get-AzSqlElasticPool.
Austin Deal commented
Thanks for the feedback here. As of 2019-11-11, a new database metric is available that shows the total aggregate backup storage usage for each vCore database. It is broken down by backup type (Full, Diff, Log) to hopefully give better insight to where the backup storage usage is coming from.
https://docs.microsoft.com/en-us/azure/azure-monitor/platform/metrics-supported#microsoftsqlserversdatabases has details on this new metric (full_backup_size_bytes, diff_backup_size_bytes, log_backup_size_bytes).
Please see the attached screenshot as an example for viewing this metric in the Azure Portal.
Morten Gade commented
A must when PITR storeage is billed!
Troels Funder commented
This is much needed ASAP to gain visibility to what we actually are going to pay for. I would go that far, saying that this shoud have been availalble before you started to charge us!
Eric Lakey commented
I'm glad to hear you are developing an API for this as not having visibility into the backup usage is causing a lot of trouble since we cannot manage these costs without it.
Alexander Nosov [sashan@MSFT] commented
@Cameron B, thank you for the feedback. We are developing an API to visualize the running backup storage usage. Your suggestion is one of the options we are evaluating. So stay tuned.