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, ...
