Anna Hoffman and Uros Milanovic from Microsoft Developer discuss the new Next-gen GP tier for Azure SQL Managed Instance, highlighting performance enhancements and new features for database users.

Azure SQL Managed Instance Performance Enhancements with Next-Gen GP

Presented by Anna Hoffman and Uros Milanovic

The Next-gen General Purpose (GP) tier for Azure SQL Managed Instance brings major performance upgrades. Key improvements and features discussed:

What Is Next-gen GP?

• Designed to deliver lower latency and higher throughput compared to the Classic GP tier
• Enables higher IOPS and more storage per managed instance
• Supports additional databases per instance
• Introduces sliders for fine-grained control over IOPS and memory resources

Classic GP vs. Next-gen GP

• Direct comparison of performance and resource limits between the Classic and Next-gen GP tiers
• HammerDB-TPROC-C Test Results: Demonstrates the performance capability gains in transactional workloads

Portal User Experience

• Walkthrough of the Azure Portal showing adjustable sliders for IOPS and memory
• Simplified interface for configuring compute and storage

User Value

• Greater flexibility for users to tailor Azure SQL Managed Instance deployments to their workload requirements
• Cost-effective scaling and optimized performance for demanding database scenarios

Getting Started

• Guidance on how to migrate or start with Next-gen GP
• Reference documentation and resources:
  • Azure SQL MI Next-gen GP Blog
  • Product Documentation
  • Free Trial
  • Azure Arc Migration Docs

Connect with the Team

• Twitter: Anna Hoffman, AzureSQL
• More episodes: Data Exposed YouTube
• Additional channels: Microsoft Azure SQL, Microsoft SQL Server, Microsoft Developer