Can I move an SQL elastic pool from a DTU based model to a Hyperscale Serverless model ?

Question

Hi we have 8 databases sitting in a 200 DTU elastic pool - 7 of the databases are small and aren't used much one is large in comparison (~900Gb) and heavily used in an overnight batch process and occasionally during the day. We are now getting to the limits of the size we can use in an elastic pool and it makes sense to move this to hyperscale, ideally serverless hyperscale as we think this may give us the best flexibility in terms scalability going forward. The serverless option looks good in terms of costing for what we are doing where the database is quiet most of the day and busy for about 1-2 hours a day. However I cannot see an option to move the elastic pool to hyperscale (see image attached) - is this available for elastic pools - if not - is the best option to move the all the databases individually to serverless hyperscale or maybe just the busy larger one and the other 7 to some minimal other service ? Many thanks, Richard

Answer 1

Hi, @Richard Craig Welcome to the Microsoft Q&A forum, Thanks for posting your question.

Adding to what @Alberto Morillo Mentioned.

The Serverless compute tier is currently in public preview for standalone Hyperscale databases. It is definitely possible to migrate individual DBs from the existing DTU elastic pool, one by one, to individual standalone Hyperscale Serverless DBs. The entire pool cannot be moved to Hyperscale Serverless.

 Do ensure that once you move the previously pooled DBs one by one to standalone Hyperscale Serverless DBs, each is going to be charged individually. Also currently there is no auto-pause for Hyperscale Serverless DBs, so the amount of savings you might see needs to be determined, as the maximum savings in serverless DBs typically is seen when the DB goes to an auto-paused state (which is currently not supported for Hyperscale Serverless).

I hope this information helps.

Regards

Geetha

 

Answer 2

Hyperscale serverless is in preview at this time, maybe you may want to wait for GA to move Production workloads to this preview feature. From performance and pricing perspective it makes sense, if you don't care the feature is in preview.

Alternatively, you can move the database to Azure SQL DTU Premium tiers (P11 & P15) have a 4 TB limit, but P11 can cost you about US$6,900 per month.

Finally, Azure SQL Serverless (vCore) allows database size up to 4 TB but my suggestion is to test if performance is good enough for a Production database.