title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic |
---|---|---|---|---|---|---|---|---|
Use Next-gen General Purpose service tier (preview) |
Learn how to use the Next-gen General Purpose service tier (preview) in Azure SQL Managed Instance, which is an architectural upgrade to the existing General Purpose service tier that can be used for new and existing instances. |
urosmil |
urmilano |
wiassaf, mathoma |
05/27/2024 |
azure-sql-managed-instance |
service-overview |
conceptual |
[!INCLUDEappliesto-sqlmi]
This article teaches you how to use the Next-gen General Purpose service tier upgrade for Azure SQL Managed Instance. The Next-gen General Purpose service tier is an architectural upgrade to the existing General Purpose service tier that can be used for new and existing instances.
Note
The Next-gen General Purpose service tier upgrade is currently in preview.
[!INCLUDE azure-sql-managed-instance-compare-service-tiers]
To upgrade an existing instance to the Next-gen General Purpose service tier in the Azure portal, follow these steps:
-
Go to your SQL managed instance resource in the Azure portal.
-
Select Compute + storage under Settings to open the Compute + storage pane.
-
On the Compute + storage pane, select Enable for Next-gen General Purpose (preview):
:::image type="content" source="media/service-tiers-next-gen-general-purpose-use/existing-instance.png" alt-text="Screenshot of the compute and storage page for your instance in the Azure portal, with next-gen general purpose selected.":::
-
After Next-gen General Purpose (preview) is enabled, you can use sliders to modify the IOPS for the instance, and review the Cost per IOPS in the Estimated costs per month box.
-
Select Apply to save your changes.
Note
For instances inside of a failover group, changing the service tier to, or from, the Next-gen General Purpose tier isn't supported. You must first delete the failover group before modifying either replica, and then re-create the failover group after the change takes effect.
You can use the Next-gen General Purpose tier upgrade for new instances when you deploy them in the Azure portal. To do so, follow these steps:
-
Go to the Create Azure SQL Managed Instance pane in the Azure portal.
-
On the Networking tab, under Virtual network / subnet, select a subnet from the dropdown that is Ready for November 2022 feature wave.
-
On the Basics tab, select Configure Managed Instance under Compute + storage to open the Compute + storage pane:
:::image type="content" source="media/service-tiers-next-gen-general-purpose-use/new-instance-configure.png" alt-text="Screenshot of the Create Azure SQL Managed Instance page in the Azure portal, with Configure Managed Instance selected.":::
-
Select Enabled for Next-gen General Purpose (preview) and then use the slider to modify IOPS for your instance. Review the Cost per IOPS in the Estimated costs per month box:
:::image type="content" source="media/service-tiers-next-gen-general-purpose-use/new-instance-configure-managed-instance.png" alt-text="Screenshot of the compute + storage page when you configure your new Azure SQL Managed in the Azure portal.":::
-
Select Apply to save your instance configuration and go back to the Create Azure SQL Managed Instance pane.
-
Fill out the rest of the values to configure your new instance.
-
Select Review + create to review your settings, and then select Create to deploy your new instance using the Next-gen General purpose tier upgrade.
- To get started, see Creating a SQL Managed Instance using the Azure portal
- For pricing details, see
- For details about the specific compute and storage sizes available in the General Purpose and Business Critical service tiers, see vCore-based resource limits for Azure SQL Managed Instance.
- SLA for Azure SQL Managed Instance
- Frequently asked questions