August 2017
Intermediate to advanced
468 pages
12h 5m
English
Content preview from Serverless computing in Azure with .NET
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Azure SQL Database pricing based on load
To estimate the monthly and yearly growth of the database size, let's assume that a single user request generates the data growth of approximately 10 KB.
If you want to calculate the approximate database size for your typical data, you can run the sp_spaceused 'Tablename' query on your SQL database to estimate the average row size of each SQL table.
Keep in mind that you do not have to reserve the highest needed tier for the whole year, as you can perform a zero-downtime scale up in minutes. If the database gets large over time, you could also explore archival storage for older transactions to save costs.
Price as a function of load:
1,000 requests a day
- Monthly growth: 1,000 * 31 * 10 KB = 310 MB, ...