AzureRecipes

The Azure SQL PaaS service has quite a big variety of service tiers and according configurations. This snippet provides the cheapest configuration which can be seriously used for productive applications. This configuration serves low usage / performance requirements, but can easily be scaled to mid-range use cases. It also includes the network configuration to allow access for all Azure services (e.g. App Service or Synapse).

Further information to service models / tiers:

• MSDN Choose between the vCore and DTU purchasing models
• Purchase model vCore: Allows cost-savings with Hybrid Benefit and Reserved Instances, but is generally rather expensive
  • Tier Provisioned: Several sizes available
  • Tier Serverless: Caution when allowing down-scaling to zero instances (long latencies possible)
• Purchase model DTU: Very difficult to pre-estimate the required size, but generally very cost-efficient
• Scale up/down: Except for the serverless tier (vCore purchase model), there is no easy configurable auto-scaling available, only a manual scaling by adjusting the size (no to minimal downtime). This can be automated with e.g. an Automation Account script

This site is open source. Improve this page.