An Azure relational database service.
Hi @Anonymous ,
Greetings!!
It sounds like you're trying to get a handle on the storage costs for Azure SQL Database Hyperscale in different scenarios. Let’s break down the calculations based on the information you provided.
1.Billing Formula Confirmation
Yes, your understanding is correct. Azure bills Hyperscale storage hourly, based on the allocated size, using the formula:
Hourly prorated cost:
Cost=Allocated GB×Price per GB-month×(Hours keptHours in month)\text{Cost} = \text{Allocated GB} \times \text{Price per GB-month} \times \left( \frac{\text{Hours kept}}{\text{Hours in month}} \right)Cost=Allocated GB×Price per GB-month×(Hours in monthHours kept)
For a simple estimate, this can be approximated as:
Cost≈Allocated GB×Price per GB-month×(Days keptDays in month)\text{Cost} \approx \text{Allocated GB} \times \text{Price per GB-month} \times \left( \frac{\text{Days kept}}{\text{Days in month}} \right)Cost≈Allocated GB×Price per GB-month×(Days in monthDays kept)
2.GB Conversion:
1 TB = 1024 GB
Azure uses binary conversion for storage billing, so:
1TB = 1024 GB
Therefore, 100 TB = 102,400 GB
3.Cost Calculation Examples
Assuming:
Price per GB-month = $0.25
Allocated size = 100 TB = 102,400 GB
For 30 days:
102,400×0.25=$25,600102,400 \times 0.25 = $25,600102,400×0.25=$25,600
For 7 days (in a 30-day month):
25,600×730≈$5,973.3325,600 \times \frac{7}{30} \approx $5,973.3325,600×307≈$5,973.33
These calculations are correct and match how Azure bills Hyperscale storage.
4.Impact of Hyperscale Backups
- With default backup retention (typically 7 days) and no long-term backup configured, the storage cost does not change for your scenarios. Hyperscale backups are stored in separate storage and billed separately under Backup Storage, which is free up to the retention period for most configurations.
- Only incurs cost if additional backup storage is used (e.g., long-term retention or large DBs with frequent changes).
- So for your 7-day and 30-day scenarios with default retention, no additional cost is expected from backups.
For more information, please refer the document:
Automated backups for Hyperscale databases.
I hope this information helps. Please do let us know if you have any further queries.