In a recent video, I took a hands-on look at the Next Gen General Purpose service tier in Azure SQL Managed Instance—and it brings some exciting advancements to the table!
This update marks a significant evolution in the managed database space, offering improved performance, enhanced storage capabilities, and streamlined scaling for general-purpose workloads. Whether you’re migrating existing applications to Azure or architecting new cloud-native solutions, this tier is designed to meet modern demand with greater efficiency.
One of the standout features I discussed and demo is the new memory slider capability that showcases how we can manage memory and optimize workloads— Available only in the premium series hardware, it’s definitely a feature worth looking at!
If you’re working with Azure SQL Managed Instances or considering the move, I highly recommend checking out the video:
Have thoughts, questions, or use cases to share? I’d love to hear how others are planning to incorporate the Next Gen GP tier into their data strategy!
© 2025, John Morehouse. All rights reserved.
Hi there, let me know if I’m wrong, if I have 100 db in a general purpose managed instance now, it gives me 500 IOPS per file if the are smaller than 129GiB, so a total of 100000 IOPS (considering 2 files per database) if load is spreaded, while each file is limited to 500 IOPS and only 100 MiB/s of throughtput. By comparison a Next Gen will give me if my total storage is just 1 TB only 3072 IOPS to spread over my workload and an unspecified throughput, as it says it uses managed disk but not what kind, so I assume standard HDD, so 500MB/s. The IOPS limit for a 4 core instance in next gen is 6400 IOPS, compared to the potential 100000 IOPS I have in this example. ¿am I calculating anything wrong? Thanks.