How to change maximum server memory in Azure SQL Managed Instance

Question

How to change maximum server memory in Azure SQL Managed Instance

Ma. Kassandra Bernabe 45

Hi,

We like to update my Maximum Server Memory in SQL Managed Instance to lessen the memory consumption, but it was disabled when we checked the settings in the Server memory options of our SQL Server

User's image

We already checked it in the Azure Portal, but no option for Server Parameters in the settings.

User's image

We use the Business Critical tier in the SQL Managed Instance. We were able to change Server memory option in other SQL like SQL for VM, but only in SQL Managed Instance, we encountered an issue. Is there other way to change the Maximum Server Memory in the SQL Managed Instance?

Mahesh Kurva 7,570 Reputation points Microsoft External Staff Moderator

2025-08-21T17:26:39.46+00:00

Hi Ma. Kassandra Bernabe ,

Just checking in to see if the below answer provided by @Bruce (SqlWork.com) helped.

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.

1 answer

Your answer

Mahesh Kurva 7,570 Reputation points Microsoft External Staff Moderator

2025-08-21T17:26:39.46+00:00

Hi Ma. Kassandra Bernabe ,

Just checking in to see if the below answer provided by @Bruce (SqlWork.com) helped.

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 1

Bruce (SqlWork.com) 79,601 Volunteer Moderator

In managed sql instance, you pick the max memory by the pricing plan. Once you pick a plan, you are charged for the memory whether you use or not, so there is no reason to lower. There is a minimum memory included with each core, but you pay for additional. You can reduce this additional memory if you are using any in your plan.

https://azure.microsoft.com/en-us/pricing/details/azure-sql-managed-instance/single/#pricing

Mahesh Kurva 7,570 Reputation points Microsoft External Staff Moderator

2025-08-22T16:35:32.4933333+00:00

Hi Ma. Kassandra Bernabe ,

Just checking in to see if the above answer provided by @Bruce (SqlWork.com) helped.

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.

Share via

How to change maximum server memory in Azure SQL Managed Instance

1 answer

Your answer