How can an Azure policy assess SQL Azure database capacity?

Russell H. DeGrove 6

I have a parameter

  "maxCores": {  
    "type": "Integer",  
    "metadata": {  
      "displayName": "Max Capacity",  
      "description": "The max cores or DTUs that can be specified for Sql Azure."  
    },  
    "defaultValue": 4  
  }

but it never seems to fail this check

          {  
            "not": {  
              "field": "Microsoft.Sql/servers/databases/currentSku.capacity",  
              "lessOrEquals": "[parameters('maxCores')]"  
            }  
          }

I have also tried

          {  
            "not": {  
              "field": "Microsoft.Sql/servers/databases/sku.capacity",  
              "lessOrEquals": "[parameters('maxCores')]"  
            }  
          }

I am able to check

          {  
            "field": "Microsoft.Sql/servers/databases/sku.tier",  
            "notEquals": "[parameters('allowedTier')]"  
          },

so why am I having trouble with sku capacity?

Anurag Sharma 17,576 Reputation points

2022-08-12T04:49:28.073+00:00

Hi @Russell H. DeGrove , welcome to Microsoft Q&A forum and sorry for delayed response.

Could you please confirm if you want to create deny policy to check for max cores? Meanwhile I am checking this same, correct me if I am wrong here.
Anurag Sharma 17,576 Reputation points

2022-08-18T06:38:04.51+00:00

Hi @Russell H. DeGrove , could you please check the above response and let us know if you want to create a deny policy.
WOJTAS, P. (PATRYCJA) 10 Reputation points

2024-03-07T08:47:32.99+00:00

Hi,

I have the same issue- apparently database capacity cannot be verified during database creation. This parameter can be checked only on existing database. I'm still trying to create policy that would have deny effect on selected capacity during creation.
Russell H. DeGrove 6 Reputation points

2024-03-07T14:35:12.14+00:00

"Could you please confirm if you want to create deny policy to check for max cores?" It was. I never got the 2022 responses but for some reason got notified of yesterday's. We never resolved this either.
WOJTAS, P. (PATRYCJA) 10 Reputation points

2024-03-08T09:16:20.1566667+00:00

I'm also in contact with Microsoft Support about this, we tested a few parameters that could potencially monitor capacity during database creation, but no success yet. I was hoping that it was resolved in your case, hence I added my comment to get some info.