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

Using Trim Function in MS SQL

Getting List of System Hard Disks with Free Space in MS SQL Serve ...

What is Deadlock in SQL Server ?

Getting List of All Server Databases in MS SQL

MS SQL Getting a Random Row in a Table