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

MS SQL List of Records in All Tables

Using CASE WHEN in MS SQL

Getting List of All Stored Procedures in Database in MS SQL

Benefits of Using Stored Procedures in MS SQL

Adding Columns to a Table with a Query in MS SQL