Skip to content

Azure SQL Elastic Pool resources must use standard naming#

Operational Excellence · Azure SQL Elastic Pool · Rule · 2025_12 · Awareness

Azure SQL Elastic Pool resources without a standard naming convention may be difficult to identify and manage.

Description#

An effective naming convention allows operators to quickly identify resources, related systems, and their purpose. Identifying resources easily is important to improve operational efficiency, reduce the time to respond to incidents, and minimize the risk of human error.

Some of the benefits of using standardized tagging and naming conventions are:

  • They provide consistency and clarity for resource identification and discovery across the Azure Portal, CLIs, and APIs.
  • They enable filtering and grouping of resources for billing, monitoring, security, and compliance purposes.
  • They support resource lifecycle management, such as provisioning, decommissioning, backup, and recovery.

For example, if you come upon a security incident, it's critical to quickly identify affected systems, the functions that those systems support, and the potential business impact.

For Azure SQL Elastic Pool, the Cloud Adoption Framework (CAF) recommends using the sqlep- prefix.

Requirements for Azure SQL Elastic Pool resource names:

  • Between 1 and 128 characters long.
  • Letters, numbers, and special characters except: <>*%&:\/?
  • Can't end with period or a space.
  • Must be unique for each logical server.

Recommendation#

Consider creating Azure SQL Elastic Pool resources with a standard name. Additionally consider using Azure Policy to only permit creation using a standard naming convention.

Examples#

Configure with Bicep#

To deploy resources that pass this rule:

  • Set the name property to a string that matches the naming requirements.
  • Optionally, consider constraining name parameters with minLength and maxLength attributes.

For example:

Azure Bicep snippet
@minLength(1)
@maxLength(128)
@description('The name of the resource.')
param name string

@description('The location resources will be deployed.')
param location string = resourceGroup().location

resource pool 'Microsoft.Sql/servers/elasticPools@2024-05-01-preview' = {
  parent: server
  name: name
  location: location
  properties: {
    perDatabaseSettings: {
      minCapacity: 0
      maxCapacity: 2
    }
    maxSizeBytes: 34359738368
    zoneRedundant: true
    licenseType: 'BasePrice'
    maintenanceConfigurationId: maintenanceConfigurationId
  }
}

Configure with Azure template#

To deploy resources that pass this rule:

  • Set the name property to a string that matches the naming requirements.
  • Optionally, consider constraining name parameters with minLength and maxLength attributes.

For example:

Azure Template snippet
{
  "$schema": "https://schema.management.azure.com/schemas/2019-04-01/deploymentTemplate.json#",
  "contentVersion": "1.0.0.0",
  "parameters": {
    "name": {
      "type": "string",
      "minLength": 1,
      "maxLength": 128,
      "metadata": {
        "description": "The name of the resource."
      }
    },
    "location": {
      "type": "string",
      "defaultValue": "[resourceGroup().location]",
      "metadata": {
        "description": "The location resources will be deployed."
      }
    }
  },
  "resources": [
    {
      "type": "Microsoft.Sql/servers/elasticPools",
      "apiVersion": "2024-05-01-preview",
      "name": "[format('{0}/{1}', parameters('name'), parameters('name'))]",
      "location": "[parameters('location')]",
      "properties": {
        "perDatabaseSettings": {
          "minCapacity": 0,
          "maxCapacity": 2
        },
        "maxSizeBytes": 34359738368,
        "zoneRedundant": true,
        "licenseType": "BasePrice",
        "maintenanceConfigurationId": "[parameters('maintenanceConfigurationId')]"
      }
    }
  ]
}

Notes#

This rule does not check if Azure SQL Elastic Pool resource names are unique.

Rule configuration#

AZURE_SQL_ELASTIC_POOL_NAME_FORMAT

To configure this rule set the AZURE_SQL_ELASTIC_POOL_NAME_FORMAT configuration value to a regular expression that matches the required format.

For example:

configuration:
  AZURE_SQL_ELASTIC_POOL_NAME_FORMAT: '^sqlep-'

Comments