Azure Auto-Scale Database

Question

I am using the Azure Cloud Services with a single Azure Database. I have the pricing tier set to S4 which gives me 200 DTUs and 250GB. The issue is that all of my worker and web roles are set to auto-scale with load except for the Database. When I do a load-test, everything up-scales automatically until the Database starts choking on queries which is causing a bottle-neck.

There isn't any auto-scaling options for Databases that I can find. I found this video from Microsoft: Azure SQL Database dynamically scale-up or scale-down

but it basically says that you need to go to your Azure portal and manually scale-up to a larger pricing tier. It doesn't mention anything about automatically scaling up or down.

I also looked into Elastic Pools but these seem to be more for using many Databases at the same time, rather than just 1 Database.

So my question is:

How do you automatically scale-up and down a single Azure database?

Answer 1

You have several options like Alberto mentioned you can use REST API and Of course azure run-books/webhooks to configure the alert rules.

Let me explain my process here.

1. Deploy the azure run-books for the changing the performance tier in AzureAutomation -Try this
2. Create some webhooks for triggering your run-books anytime -Webhooks for Azure runbook
3. From your SQL DB, create an alert rule with the condition when DTU used greater than or equal to some value (say 1600) the call the corresponding webhook to change the tier dynamically.