Upgrade Azure SQL Managed Instance to November 2022 Feature Wave

Question

Upgrade Azure SQL Managed Instance to November 2022 Feature Wave

Ian Keogh 25

How can an Azure SQL Managed Instance (GP Premium Series) be upgraded to the November 2022 Feature Wave? The current version is [Jul 2 2024 15:39:01] via SELECT @@VERSION.

The goal is to utilize the Next-gen General Purpose tier for increased database limits and to benefit from always-up-to-date patching for the new JSON datatype.

Is it necessary to create a new VNET and Subnet that complies with the requirements, and then select them in the SQL Managed Instance's networking settings? Can existing Network Security Groups (NSGs) be reused, or is a new setup required?

The objective is to achieve this upgrade with minimal downtime, ideally under 2 hours, without having to rebuild the Azure SQL Managed Instance from scratch.

Sai Raghunadh M 4,045 Reputation points Microsoft External Staff Moderator

2024-10-15T23:33:14.1566667+00:00

Hi @Ian Keogh,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ian Keogh 25 Reputation points

2024-10-16T12:06:31.7066667+00:00

Hi, I created a new vnet / subnet / routing table and an NSG. but when i goto my existing SQLMI and try to select the new VNET in networking, it does not appear in the ready section, rather in the "Not Ready" section.

So I am little confused as to why it is not ready, there are no indications of any issues.
Sai Raghunadh M 4,045 Reputation points Microsoft External Staff Moderator

2024-10-16T18:21:00.3766667+00:00

Hi @Ian Keogh,

If the VNet remains "Not Ready":

Double-check the configuration of the VNet and subnet.
Ian Keogh 25 Reputation points

2024-10-16T18:30:48.9366667+00:00

I have checked the address space, the subnet, assigned the NSG & RT to the default subnet, created a GatewaySubnet. Set teh deligation of the subnet to managedinstances.

I will most probably open a support ticket and have someone review what i have.
Sai Raghunadh M 4,045 Reputation points Microsoft External Staff Moderator

2024-10-17T18:49:29.5766667+00:00

Hi @Ian Keogh,

Just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.
Ian Keogh 25 Reputation points

2024-10-17T18:58:28.06+00:00

I did check with them and the answer i received was "Only the product group can enable the November 2022 Feature Wave on a server. it cannot be added or enabled by the customer"

Accepted answer

1 additional answer

Your answer

Sai Raghunadh M 4,045 Reputation points Microsoft External Staff Moderator

2024-10-15T23:33:14.1566667+00:00

Hi @Ian Keogh,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ian Keogh 25 Reputation points

2024-10-16T12:06:31.7066667+00:00

Hi, I created a new vnet / subnet / routing table and an NSG. but when i goto my existing SQLMI and try to select the new VNET in networking, it does not appear in the ready section, rather in the "Not Ready" section.

So I am little confused as to why it is not ready, there are no indications of any issues.
Sai Raghunadh M 4,045 Reputation points Microsoft External Staff Moderator

2024-10-16T18:21:00.3766667+00:00

Hi @Ian Keogh,

If the VNet remains "Not Ready":

Double-check the configuration of the VNet and subnet.
Ian Keogh 25 Reputation points

2024-10-16T18:30:48.9366667+00:00

I have checked the address space, the subnet, assigned the NSG & RT to the default subnet, created a GatewaySubnet. Set teh deligation of the subnet to managedinstances.

I will most probably open a support ticket and have someone review what i have.
Sai Raghunadh M 4,045 Reputation points Microsoft External Staff Moderator

2024-10-17T18:49:29.5766667+00:00

Hi @Ian Keogh,

Just checking back to see if you've had a chance to submit a support ticket. If you have, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.
Ian Keogh 25 Reputation points

2024-10-17T18:58:28.06+00:00

I did check with them and the answer i received was "Only the product group can enable the November 2022 Feature Wave on a server. it cannot be added or enabled by the customer"

Answer 1

Hi @Ian Keogh,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.

Issue:

How can an Azure SQL Managed Instance (GP Premium Series) be upgraded to the November 2022 Feature Wave? The current version is [Jul 2 2024 15:39:01] via SELECT @@VERSION.

The goal is to utilize the Next-gen General Purpose tier for increased database limits and to benefit from always-up-to-date patching for the new JSON datatype.

Is it necessary to create a new VNET and Subnet that complies with the requirements, and then select them in the SQL Managed Instance's networking settings? Can existing Network Security Groups (NSGs) be reused, or is a new setup required?

The objective is to achieve this upgrade with minimal downtime, ideally under 2 hours, without having to rebuild the Azure SQL Managed Instance from scratch.

Solution:

Only the product group can enable the November 2022 Feature Wave on a server. it cannot be added or enabled by the customer.

If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information.

Hope this helps. Do let us know if you have any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 2

Sai Raghunadh M 4,045 Microsoft External Staff Moderator

Hi @Ian Keogh,

Thanks for the question and using MS Q&A platform.

It seems that you want to upgrade your Existing SQL Managed Instance to the November 2022 Feature Wave in Next-gen General Purpose tier.

The Next-gen General Purpose tier upgrade is currently under preview.

Confirm that your current Azure SQL Managed Instance version supports the upgrade to the November 2022 Feature Wave.
Determine if the current VNet and Subnet meet the requirements for the upgrade. If not, create a new VNet and Subnet that comply.
Make sure they are configured for zone redundancy if required by the new features.
Review your existing NSGs to see if they can be reused. If they align with the security requirements of the new setup, you can continue using them.
Use the Azure portal to initiate the upgrade of the Azure SQL Managed Instance.
Select the Next-gen General Purpose tier during the upgrade process.
Plan the upgrade during off-peak hours if possible, to minimize impact on users.

To upgrade the existing SQL Managed Instance to Next-gen General purpose tier, you can try these steps. Screenshot of the compute and storage page for your instance in the Azure portal, with next-gen general purpose selected.

please go through these documents, that might help you:

Use Next-gen General Purpose service tier (preview) - Azure SQL Managed Instance.

Configure an existing virtual network for Azure SQL Managed Instance.

Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Ian Keogh 25 Reputation points

2024-10-17T18:55:47.21+00:00

Only the product group can enable the November 2022 Feature Wave on a server. it cannot be added or enabled by the customer.
Sai Raghunadh M 4,045 Reputation points Microsoft External Staff Moderator

2024-10-17T19:06:03.37+00:00

Hi @Ian Keogh,

I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.
Oury Ba-MSFT 20,901 Reputation points Microsoft Employee Moderator

2024-10-24T18:59:34.2+00:00

@Ian Keogh Thanks a lot for sharing this.

I would like to thank you for your feedback provided on survey. We found your recent engagement on this question was rated low. However, we were able to share some additional information that could helped in the later comment. Would you please re-evaluate your feedback.

For existing SQL MI instances, the Nov 22 Feature Wave can't be enabled by the customers.

We're in the process of finishing the worldwide enablement.

The upgrade will happen within the maintenance window so minimal downtime.

This article provides more details: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/doc-changes-updates-release-notes-whats-new?view=azuresql#november-2022-feature-wave

Regards,

Oury

Share via

Upgrade Azure SQL Managed Instance to November 2022 Feature Wave

1 additional answer

Your answer