- automated backups and patching,
- built-in high availability (within single and multi-zone deployments) for ensuring business continuity backed up with 99.99% uptime SLA,
- failover group setup for disaster recovery,
- online management operations,
- and much more.
All these capabilities are one click away from you as they are provided out of the box without need for complex setups and configuration.
What is next-gen general purpose Azure SQL Managed Instance?
What are the key improvements of the next-gen general purpose tier?
Category | Item | Current GP | Next-gen GP | Improvement |
Storage performance | Limits | Separate limits for each file | Shared limits for the instance | Easier to use, familiar model |
Average I/O latency (approx.)
|
5-10 ms | 3-4 ms | 2x lower I/O latency | |
Max data IOPS | 30-50k IOPS | 80k IOPS | 60% better | |
Max log throughput |
Per instance: 120 MB/s
Per DB: 22-65 MB/s |
Per instance: 192 MB/s
Per DB: no limits |
60% better
3x better |
|
Storage limits | Max storage | 16 TB | 32 TB | 2x better |
Max number of DBs | 100 DBs | 500 DBs | 5x better | |
Max number of files | 280 per instance | 4096 per database | Huge improvement! |
How to try out the next-gen general purpose tier for free?
Free Azure SQL Managed Instance
Reduce costs by using dev/test subscription and start-stop feature
- You are in the project phase where you don’t need an uptime SLA.
- You are not charged for SQL license (cost optimization).
- Your instance does not have to be online 24/7 so you can stop it out of the working hours (cost optimization).
Conclusion
The next-gen general purpose Azure SQL Managed Instance is a great option for anyone who needs a fully managed, secure, and scalable cloud database service with exceptional storage performance and limits, and more flexibility and control over the instance configuration. You can try out the next-gen general purpose tier for free or at a very low cost, by using the Free Azure SQL Managed Instance offering or dev/test subscription combined with start-stop capability. Don't miss this opportunity to experience the benefits of the next-gen general purpose tier for your applications.
Useful links