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

What is a Covered Index in SQL Server ?

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...

What Have INCLUDED Columns With SQL Server Indexes ?

What is The Concept of Piecemeal Restore on SQL Server ?

What is the XML Datatype in SQL Server ?