How to make exclusiv config changes on a managed instance

Thimo König 0

We want to make a change to the configuration of a DB which seems to be done best when there are no active users/connections to the DB. In our case we want to set READ_COMMITTED_SNAPSHOT to ON

We thought of using SINGLE_USER Mode like described here: https://video2.skills-academy.com/en-us/sql/relational-databases/databases/set-a-database-to-single-user-mode?view=sql-server-ver16 to make sure all current sessions are closed before we apply the change. But this feature is not supported by a managed instance. So we wonder what would be the best approach to apply such a change on a managed instance?

ShaktiSingh-MSFT 15,131 Reputation points

2024-08-05T11:08:04.79+00:00

Hi Thimo König •,

Welcome to Microsoft Q&A forum.

As I understand, you want to know How to make exclusive config changes on a managed instance.

I am checking with the internal team about it's possibility and will get back to you.

Thanks
Thimo König 0 Reputation points

2024-08-05T14:12:35.3766667+00:00

Hi @ShaktiSingh-MSFT ,
yes that is exactly the question: how to role out exclusive config changes on our managed instance which runs in a business-critical tier. Looking forward to your reply.

THX
ShaktiSingh-MSFT 15,131 Reputation points

2024-08-08T06:05:00.0766667+00:00

This is to inform you that reply from internal team is still awaited.

Thanks
ShaktiSingh-MSFT 15,131 Reputation points

2024-08-12T07:34:25.4966667+00:00

This is to inform you that reply from internal team is still awaited.

Thanks
ShaktiSingh-MSFT 15,131 Reputation points

2024-08-14T05:28:39.97+00:00

This is to inform you that reply from internal team is still awaited.

Thanks
Thimo König 0 Reputation points

2024-08-20T07:44:32.7+00:00

Hi @ShaktiSingh-MSFT,
we are waiting now since 15 days for an response. Any feeling about when you will get an answer from your internal Team?

Thanks

1 answer

ShaktiSingh-MSFT 15,131 Reputation points

2024-08-22T06:27:48.8066667+00:00

Hi Thimo König •,

On Azure SQL Managed Instance, this works without the need of the single user mode (which is by the way not supported on the Azure SQL MI):

Hope this helps.

Thanks
Please sign in to rate this answer.
Thimo König 0 Reputation points

2024-08-23T12:35:38.8766667+00:00

Thanks for the reply. This is what we have tried but didn't work well due to open connections of current users of the system. Like I already statet in my initial post we know that SINGLE_USER mode is not supported. That was the reason I was asking for alternatives. So we will try it like you proposed.

ShaktiSingh-MSFT 15,131 Reputation points

2024-08-26T05:31:10.4933333+00:00

Hi Thimo König •,

Thanks for the reply.

I am checking if any alternative exists.

If your requirement is urgent, you may consider raising support case for quick addressal.

Thanks

ShaktiSingh-MSFT 15,131 Reputation points

2024-08-27T05:52:57.08+00:00

Hi Thimo König •,

As communicated by the internal team:

Removing active users is from the database is a known requirement.

Thanks
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

How to make exclusiv config changes on a managed instance

1 answer

Your answer