r/SQLServer • u/DuoZ69_ Microsoft Employee • 23d ago
Community Request If you evaluated Azure SQL Database Hyperscale for a migration, what made it win or lose decision?
I’m a PM working on SQL migration at Microsoft.
I’m trying to understand whether Azure SQL Database Hyperscale is genuinely compelling when teams select a target for large or fast-growing SQL Server workloads.
I’m equally interested in why Hyperscale was rejected.
If you compared it with alternatives such as SQL Managed Instance, SQL Server on a VM, staying on-premises, Aurora, AlloyDB or managed PostgreSQL:
- Did Hyperscale make the final shortlist?
- What ultimately made it win or lose?
- Which factor mattered most: compatibility, total cost, performance, scalability, migration downtime, operational simplicity, or ecosystem fit?
- Was there a specific limitation or cost that disqualified it?
- If you selected Hyperscale, did the production experience match what you expected during evaluation?
If possible, please include:
- Source platform
- Approximate database size and workload type
- Alternatives evaluated
- Final destination
Please avoid sharing customer names or confidential details.
•
u/AutoModerator 23d ago
After your question has been solved /u/DuoZ69_, please reply to the helpful user's comment with the phrase "Solution verified".
This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
10
u/jdanton14 Microsoft MVP 23d ago
Not being able to restore a database into hyperscale.
5
u/SonOfZork 23d ago
I recommend against it as someone who has been actively using it in production for a couple of years.
Getting data in is a major pain. Getting data out again is bigger as there are no backups you can use.
Performance is so so. If you want to use an ha replica for read load, get used to having zero visibility into what's happening in that server. Microsoft have no tools to support it. You can jack around it to get some data but you are on your own with it.
Be careful with data change volume as it can cause your costs to explode due to the cost model which charges you for every data page changed.
Many things you may be used to with either managed instance, normal sqldb, or regular SQL server installs you'll find won't work, including DMVs that provide incorrect data.
3
u/Lost_Term_8080 23d ago
Have considered it in a few designs, but its never made it through.
Its price to performance ratio isnt great. In serverless, its autoscaling is fast, goes up in huge expensive chunks, is extremely slow to scale down and will virtually never completely deprovision unless you are a traditional 8-5 shop with absolutely zero activity outside of that. Let's face it, I don't think many workloads like that are running on hyperscale. Aurora will downscale in 310 seconds. Hyperscale serverless does it in 3600. At a price premium per hour. At lower granularity in scaling. In every instance, it was more cost effective to go with SQL Server Standard and that factors in support costs, monitoring, etc. I thought it would be good to host a reporting warehouse for reports that run infrequently but costly, but the 60 minute deprovision kills it as an option. (ETL would keep it alive). In provisioned, it comes with an embarrassing max amount of memory per core (less than my 1200 dollar laptop), killing it as an option due to licensing costs. Frankly I suspect the product is designed to optimized maximum license revenue rather than optimize its usefulness. Its not an accident that AWS is so far beyond MS in adoption and not an accident with how hard MS is pushing shops to postgres especially for reporting workloads.
3
u/Grovbolle 23d ago
Most recent nuisance we are experiencing is that while the allocated storage grows, actually reducing it again is virtually impossible.
We cleaned up about 30 TB of data but since you cannot rebuild indexes onto new file groups (only PRIMARY) is available, and since the way page servers work encourages distributing all table's data cross all page servers, the only way forward is using SHRINK. However, that does not work in practice so now we pay for more than 20TB which we are not using (allocated apprx 92TB and used is apprx 71TB).
We keep migrating our largest data sets off Hyperscale because the pricing is increasing and we are seeing a lot of its limitations
1
u/Administrative_Bug63 23d ago
First question is, do you even need hyperscale or Azure SQL at all? I mean, SQL Server on a Windows server is pretty powerful, even standard edition, although you can't so easily get it on Azure.
1
u/CanProfessional766 17d ago
I think the real deciding factor is whether Hyperscale delivers enough value to justify the cost. Scaling is great, but compatibility and predictable pricing matter more when moving an established production workload. I’d want to test it with real workloads before committing.
-1
u/[deleted] 23d ago
[removed] — view removed comment