SQL Server: How to find out whether Dedicated Administrator Connection (DAC) is in use?

Hi Friends, Many of you would have read about or used DAC (Dedicated Administrator Connection). Introduced in SQL Server 2005, this is a special purpose connection only to be used in extreme connections when you are not able to connect to SQL Server by any other means. You can use this technique to troubleshoot and [...]