What is the Use of Dedicated Admin Connection ?

Dedicated Admin Connection allows user to connect to SQL server when normal connection attempts fail, for example, when a server is hanging, out of memory or other bad states that it's not responding to connection requests. DAC is achieved by pre-allocating dedicated resources during server startup, including memory and scheduler etc.



You May Interest

Finding Session Id in MS SQL User's Current Process

Changing MS SQL Table Name with Query

How is Deadlock Different From a Blocking Situation in SQL Server ...

What are the Different Recovery Models Inside SQL Server ?

Adding Columns to a Table with a Query in MS SQL