Azure SQL Elastic Pool Builder

StorageAzure

Build SQL Elastic Pool configs with DTU or vCore sizing, per-database min/max settings, zone redundancy, and backup retention.

Azure SQL Database Configuration

Build SQL Elastic Pool configs with DTU or vCore sizing, per-database min/max settings, zone redundancy, and backup retention policies.

Required Fields

elasticPoolNameserverNameresourceGrouppricingModeldatabases

{
  "elasticPoolName": "sqlpool-contoso-prod",
  "serverName": "sql-contoso-prod",
  "resourceGroup": "rg-database",
  "location": "eastus2",
  "pricingModel": "vCore",
  "vCoreConfig": {
    "tier": "GeneralPurpose",
    "family": "Gen5",
    "vCores": 8,
    "maxStorageGB": 512,
    "zoneRedundant": true,
    "licenseType": "BasePrice",
    "perDatabaseSettings": {
      "minCapacity": 0,
      "maxCapacity": 4
    }
  },
  "dtuConfig": {
    "tier": "Standard",
    "totalDTUs": 800,
    "maxStorageGB": 500,
    "perDatabaseSettings": {
      "minDTUs": 0,
      "maxDTUs": 100
    }
  },
  "databases": [
    {
      "name": "db-orders",
      "currentSizeGB": 45,
      "peakDTU": 80,
      "avgDTU": 25,
      "peakVCores": 3.2,
      "avgVCores": 0.8
    },
    {
      "name": "db-customers",
      "currentSizeGB": 22,
      "peakDTU": 60,
      "avgDTU": 15,
      "peakVCores": 2.4,
      "avgVCores": 0.5
    },
    {
      "name": "db-inventory",
      "currentSizeGB": 38,
      "peakDTU": 95,
      "avgDTU": 30,
      "peakVCores": 3.8,
      "avgVCores": 1.0
    },
    {
      "name": "db-analytics",
      "currentSizeGB": 120,
      "peakDTU": 50,
      "avgDTU": 10,
      "peakVCores": 2.0,
      "avgVCores": 0.3
    },
    {
      "name": "db-notifications",
      "currentSizeGB": 5,
      "peakDTU": 20,
      "avgDTU": 5,
      "peakVCores": 0.8,
      "avgVCores": 0.2
    }
  ],
  "maintenanceWindow": {
    "dayOfWeek": "Saturday",
    "startHour": 2,
    "duration": "PT6H"
  },
  "backupStorage": {
    "redundancy": "Geo",
    "retentionDays": 35,
    "longTermRetention": {
      "weeklyRetention": "P4W",
      "monthlyRetention": "P12M",
      "yearlyRetention": "P5Y",
      "weekOfYear": 1
    }
  },
  "tags": {
    "environment": "production",
    "team": "database-engineering"
  }
}

Generated Output

Output will appear here...

How It Helps

Build SQL Elastic Pool configs with DTU or vCore sizing, per-database min/max settings, zone redundancy, and backup retention. This tool helps Azure engineers generate valid configurations quickly without consulting documentation, reducing errors and accelerating infrastructure deployment. All processing runs in your browser with no data sent to external servers.

Things Engineers Ask

Does this tool connect to my Azure account?

No. This tool runs entirely in your browser and generates configuration JSON that you can copy and paste into your infrastructure-as-code templates, CLI commands, or cloud console. It never connects to any cloud account or sends data externally.

Are the generated configurations production-ready?

The tool produces syntactically valid configurations based on current Azure service specifications. Always review generated configs against your organization security policies and test in a non-production environment before deploying.

Practical Applications

1Generating azure sql elastic pool configurations for new infrastructure deployments.
2Validating existing configurations against best practices before applying changes.
3Learning Azure service configuration patterns through interactive examples.
4Accelerating infrastructure-as-code development by producing correct JSON/YAML starting points.

Related Learning Guides

Storage Account Types22 min read
Cosmos DB Consistency Levels24 min read

Was this tool helpful?

Disclaimer: This tool runs entirely in your browser. No data is sent to our servers. Always verify outputs before using them in production. AWS, Azure, and GCP are trademarks of their respective owners.