SQL MI pools: optimize costs with small 2-vcore instances

Post Content

SQL MI pools (“instance pools”) present a great way to cost-optimize small SQL Servers in Azure while leveraging PaaS (Platform-as-a-Service) benefits. This episode discusses the latest instance pools features as well as typical use cases. Instance pools are Generally Available since November 2024.

Chapters:
0:00 Interview
1:49 Provisioning
2:20 Flexibility
3:14 When to instance pools?
6:20 Example: consolidate & redistribute
11:55 Getting started

Resources:
What is an instance pool: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/instance-pools-overview?view=azuresql
General Availability announcement: https://techcommunity.microsoft.com/blog/azuresqlblog/azure-sql-managed-instance-pools-general-availability/4304474
Slide deck: https://aka.ms/sqmi-pools-deck

Let’s connect:
Twitter – Anna Hoffman, https://twitter.com/AnalyticAnna
Twitter – AzureSQL, https://aka.ms/azuresqltw

Watch even more Data Exposed episodes: https://aka.ms/dataexposedyt

Subscribe to our channels for even more SQL tips:
Microsoft Azure SQL: https://aka.ms/msazuresqlyt
Microsoft SQL Server: https://aka.ms/mssqlserveryt
Microsoft Developer: https://aka.ms/microsoftdeveloperyt