WebApp + SQL in Prodcution Environment

Joshua Davies 1 Reputation point
2022-08-26T00:23:02.997+00:00

I am looking to launch a WebApp that has an SQL database as well as blob storage. The application will be up and running for a period of 2 years.

My estimated requirements are listed below:

  • SQL database to hold a maximum of a 100 MB of data
  • BlobStorage will hold a maximum of 1TB
  • API will perform simple database queries using entity framework on what would be a maximum of 10,000 records
  • WebApp will have a maximum of 15 users at one time
  • Database backup functionality that performs a backup every 24 hours

As i move this into a Production environment i am hoping to get recommendations for the type of setup i need in Azure and potentially even an estimation for how much it will cost to have this hosted on a monthly basis.

Thank you in advance.

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,721 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,956 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ajkuma 22,521 Reputation points Microsoft Employee
    2022-08-31T19:51:46.97+00:00

    JoshuaDavies-4268, As SaiKishor-MSFT mentioned, you can leverage Azure Pricing calculator to get a cost estimate for running Azure resources.

    For App Service WebApp, for the production workloads it’s recommended to leverage the dedicated Standard pricing tier or above.
    While the price goes up for higher tiers, it also gives you more memory and storage and higher-performing hardware, giving you higher app density per compute instance.

    Kindly checkout this doc for detailed insights on: Plan and manage costs for Azure App Service

    Depending on your needs you will have purchase a separate database tier.
    You can either leverage serverless Azure SQL server or General Purpose PostgreSQL flexible server - You can start with lower tier database and then scale these services up or down to fit your needs.

    Reservation and Cost Optimization:

    Additionally, you can get a discount of up to 72 percent* over pay-as-you-go pricing on Azure services when you prepay for a one- or three-year term with reservation pricing.
    Checkout this doc for more info.

    With Azure Cost Management features, you can explore, analyze, budget, and optimize costs for your subscription.
    Explore and analyze costs with cost analysis

    [[Azure pricing calculator]
    Pricing calculator

    0 comments