Vishnu Ranganathan Vishnu Ranganathan - 2 months ago 17
reST (reStructuredText) Question

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 ??

Answer Source

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