what is the estimate?

Question

Estimate the costs on one of the following three platforms to meet these requirements: • 400 Gb of database storage initially • 10 Gb new DB each month • 100 users • At least 2 clusters (servers) for availability • 800 Gb file storage • Backup every day • Retain backups for 30 days

Answer 1

Here's an Azure cost estimate based on your requirements:

1. Azure SQL Database (Managed Instance)

1. Initial Database Storage: 400 GB
2. Growth: 10 GB per month (assuming incremental growth)
3. Users: 100
4. Clusters for High Availability: 2 nodes (Standard HA setup)

Azure SQL Managed Instance (General Purpose)

1. vCore Pricing: 8 vCores, 32 GB RAM (based on typical requirements for 100 users with HA)
2. Storage: 400 GB + (10 GB * 12 months) = ~520 GB over a year
3. Estimated Monthly Cost: ~$1,200 - $1,500

2. Azure Blob Storage (For File Storage)

1. Initial File Storage: 800 GB
2. Pricing for Hot Tier (frequent access): $0.0184 per GB
3. Total Cost for 800 GB: $14.72 per month

3. Backup Storage for Azure SQL

1. Daily Backups: Assuming differential backups with 30-day retention.
2. Estimate: 400 GB * 30 (retention) = ~12 TB
3. Backup Storage Cost: $0.02 per GB for long-term backup storage
4. Monthly Backup Cost: ~$240

4. Total Azure Estimate

1. SQL Managed Instance: $1,200 - $1,500 per month
2. Azure Blob Storage: $14.72 per month
3. Backup Storage: ~$240 per month

Estimated Total Monthly Cost: $1,454 - $1,754

This estimate is a general one, and the actual costs can vary depending on specific factors such as the region, database workload, and file access frequency.