Azure SQL - quick up/down-scale time, NO DISCONNECTIONS -> VERY COOL FEATURES!!!
We are using a Azure SQL P2 db, hosted on West Europe datacenter, for our production site
Every morning at 8.30am I’m upscaling this db from p2->p4 and 10 hours later I downscale it back to p2.
Two days ago I realized that the upscale/downscale process took only a few seconds instead of 5 minutes and there were no disconnections with my production site!!!
I’m using Azure SQL for the last 3,5 years and these two features (quick up/down-scale time, NO DISCONNECTIONS!!!) were a headache !!!!
I searched for what’s new documentation announcing these new features of Azure SQL but I haven’t found anything yet!
A big THANK YOU for these COOL features!!!
Jerry Hoffmeister commented
We recently tried doing something similar to what you describe but found that the scale up and down DID take time and DID cause disconnects (we often have long running queries). Seems like when it tries to scale, if a query is in progress, it will wait 10 minutes and if it doesn't finish, will KILL it then revokes access until the scaling is complete. And this happens silently - the query appears to succeed!