Muokkaa

Jaa

What is an instance pool? - Azure SQL Managed Instance

  • Artikkeli

Applies to: Azure SQL Managed Instance

This article provides an overview of the instance pool deployment option for Azure SQL Managed Instance, which brings substantial cost saving benefits to customers.

Instance pools make it possible to deploy multiple instances with shared resources, which provide a convenient and cost-effective infrastructure to migrate multiple databases from SQL Server instances without having to consolidate smaller and less compute-intensive workloads onto a larger SQL Managed Instance.

To get started, review Create an instance pool.

Overview

Instance pools in Azure SQL Managed Instance allow you to deploy multiple instances with shared resources onto a single underlying virtual machine within a virtual cluster.

Instance pools provide the following core benefits:

  • Ability to host 2-vCore instances, which are only available within instance pools
  • Predictable and fast instance deployment time (up to 10 minutes).
  • Cost-saving infrastructure when migrating multiple SQL Server instances.

The following diagram illustrates an instance pool with multiple managed instances deployed to a virtual cluster in a virtual network subnet:

Diagram of instance pool with multiple instances in a single pool.

What's new?

November 2024 brings the following capabilities:

  • Create pools, create instances within a pool, and modify pool configuration settings in the Azure portal.
  • Update pool configuration settings (such as compute size, license, properties) by using PowerShell or the Azure CLI.
  • Support for premium-series hardware.
  • Move an instance in and out of the pool by using PowerShell or the Azure CLI.
  • Instance pool support for reservations pricing.

Architecture

Instance pools have a similar architecture to single managed instances. To support deployments within Azure virtual networks and provide isolation and security for customers, instance pools also rely on virtual clusters. A virtual cluster represents a dedicated set of isolated virtual machines deployed inside the customer's virtual network subnet. All single instances and instance pools within the same subnet belong to the same virtual cluster. Instances within a pool have compute resources allocated to SQL Server processes and gateway components, which ensure predictable performance. After initial pool deployment, management operations on instances in a pool are faster as the SQL processes are created on compute resources that have already been provisioned.

The compute size of the virtual machine is based on the total number of vCores allocated to the pool, which are distributed between instances in the pool. This architecture allows partitioning of the virtual machine into multiple instances that can be any supported size, including 2 vCores (exclusive to instance pools). For example, when you deploy an 8-vCore instance pool, you can deploy two 2-vCore and one 4-vCore instance. You can then migrate your SQL Server databases to the instances within the pool. Since instance pools support native virtual network integration, you can deploy multiple instance pools, as well as multiple single instances, to the same subnet.

Instance pools provide a high level of isolation as each instance is granted dedicated vCores on the underlying host virtual machine. The main difference of an instance pool deployment model compared to a single managed instance is that, with instance pools, multiple SQL Server processes can be created within the same virtual machine, which are resource governed using Windows job objects. If process-level isolation is not sufficient, consider using single instances instead of instance pools, as single instances only have a single SQL Server process on the virtual machine node, providing VM-level isolation

The following diagram illustrates the main architectural difference between the two deployment models:

Diagram showing Instance pool and two individual instances in the virtual cluster.

Application scenarios

Consider using instance pools for the following scenarios:

  • Migrating a group of small SQL Server instances at the same time, where the instances are 2- or 4-vCores.
  • You need quick and predictable instance creation or scaling. For example, deployment of a new tenant in a multitenant SaaS application environment that requires instance-level capabilities.
  • Having a fixed cost or spending limit is important. For example, running shared dev-test or demo environments of a fixed (or infrequently changing) size, where you periodically deploy managed instances when needed.

Instance pools are particularly well suited for migrating multiple SQL Server instances, since pre-provisioning shared compute resources according to your total migration requirements reduces overall cost of ownership after migration. For example, consider a scenario to migrate four small on-premises SQL Server instances to Azure SQL Managed Instance. Without an instance pool, you would provision four separate single SQL managed instances with a minimum of 4 vCores each, all with their own dedicated resources. An instance pool reduces this cost since you can deploy all instances with 2 vCores each to the pool where resources are shared by the pool.

Instance and pool properties

The following properties are configured at the pool level for all instances in the pool:

Additionally, consider the following:

  • Managed instances created in pools support the same compatibility levels and features available to single managed instances.
  • Optional features or features that require you to choose specific values (such as instance-level collation, time zone, public endpoint for data traffic, failover groups) are configured at the instance level and can be different for each instance in a pool.
  • Because instances deployed to a pool share the same virtual machine, consider disabling features that introduce higher security risks, or to firmly control access permissions to these features, such as CLR integration, native backup and restore, database email, etc.
  • You can configure your SQL Managed Instance to use Microsoft Entra authentication before or after it's added to the pool.
  • Every managed instance deployed in a pool has a separate SQL Server Agent.

Resource limits

When you deploy an instance to a pool, there are limits to each individual pooled instance, and limits to the resources used by the overall pool.

The following table details limits for both pooled instances, and the pool:


 Pool limits Pooled instance limits
Service tier General Purpose General Purpose
Hardware tier Standard-series (Gen5)
Premium-series		 Standard-series (Gen5)
Premium-series
Number of vCores1 8-16-24-32-40-64-80 2-4-8-16-24-32-40-64-80
Max storage 32 TB2 - 640 GB for 2 vCores
- 2 TB for 4 vCores
- 8 TB for 8 vCores
-16 TB for 16+ vCores
Max # of databases 500 - 50 for 2 vCores
- 100 for 4+ vCores
Max # of instances 40 N/A

1 vCore options for pooled instances depend on the number of available vCores in the instance pool.
2 Pool storage limit is dictated by the sum of the storage for all instances in the pool.

For all other instance level limits, review Resource limits.

Performance considerations

Although managed instances within pools have dedicated vCore and RAM, they share a local disk (for tempdb), and network resources. Although unlikely, it's possible to experience a noisy neighbor effect from multiple instances in the pool have high resource consumption at the same time.

If you're experiencing this behavior, consider increasing the pool size, or redeploying the high consuming resources as a single instance outside the pool.

Instance pool billing

Instance pools allow you to scale compute and storage independently. You pay for:

  • Compute allocated to the pool, measured in vCores
  • Storage associated with every instance measured in gigabytes (the first 32 GB are free of charge for every instance).

vCore price for a pool is charged regardless of how many instances are deployed to that pool. Setting different pricing options isn't possible for individual instances in a pool. All instances in the pool must use the same licensing model. The license model for the pool can be altered after the pool is created.

The compute price (measured in vCores), depends on whether or not you're paying the full SQL Server license price. The following two price options are available:

  • License included: The price of the SQL Server licenses is included.
  • Azure Hybrid Benefit: A reduced price that includes the Azure Hybrid Benefit for SQL Server. Customers can opt into this price by using their existing SQL Server licenses with Software Assurance.

For full instance pool pricing details, refer to the instance pools section on the SQL Managed Instance pricing page.

Note

Instance pools created on subscriptions eligible for the dev-test benefit automatically receive discounted rates of up to 55 percent on Azure SQL Managed Instance.

Reservations pricing

Azure Reservations lets you save on compute cost by providing a deep discount when you reserve the price of resources for a predetermined period. You can now allocate reservations to an instance pool, which creates the most cost-effective way to run multiple instances.

Limitations

To learn more, review instance pool limitations.

Next steps

Configure an instance pool