Search code examples
restazure-sql-databaseazure-resource-managerazure-database-mysql

How to set DTU for Azure Sql Database via Api?


I am able to create the Azure Sql database by mentioning the pricing tier.

I am trying to set the Memory and DTU for the database.

I am not able to find the Correct Api , Here is what i tried

PUT :    https://management.azure.com/subscriptions/<subscription-ID>/resourceGroups/<Resource-group-Name>/providers/Microsoft.Sql/servers/<Server-name>/databases/<Database-name>/?api-version=2014-04-01

Request Body :

 {
                "location": "East Asia",
                "properties": {
                    "edition": "Premium",
                    "collation":"SQL_Latin1_General_CP1_CI_AS",
                "sampleName": "blank database",
                "serviceTierAdvisors":[
                    {
                        "maxSizeInGB":"150",
                        "maxDtu":"500"
                    }   
                    ]
                }   
    }

I am not getting the proper error message also , Can anyone guide me with the Parameter for setting DTU at Database Level ??


Solution

  • Can anyone guide me with the Parameter for setting DTU at Database Level ??

    The correct DTU parameter should be requestedServiceObjectiveName. Its type is enum. You could set following values for this property.

    Basic, 
    S0, S1, S2, S3
    P1, P2, P4, P6, P11, P15
    System, System2
    ElasticPool
    

    Please check the corresponding DTU values as following.

    Basic(5DTU), 
    S0(10DTU), S1(20DTU), S2(50DTU), S3(100DTU)
    P1(125DTU), P2(250DTU), P4(500DTU), P6(1000DTU), P11(1750DTU), P15(4000DTU)
    System, System2
    ElasticPool