Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Dedicated Administrator Connection (DAC) can be used to troubleshoot an unresponsive SQL Server Instance

Nov 21 2011 5:45AM by Alpesh Patel   

When a DBA observes performance problems with a SQL Server instance, usually the first action he/she takes is to run some diagnostic queries that help him/her to identify the most expensive queries running on the server. Sometimes, you may observe that the server is completely unresponsive and you are not able to connect and run your diagnostic queries.

Dedicated Administrator Connection (DAC) can be used in such a scenario to connect to the SQL Server instance and run your diagnostic queries even when SQL Server is not responding to regular connection requests.

Read More..   [18 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


Alpesh Patel
36 · 5% · 1663
5
 
3
 
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

4  Comments  

  • You can also identify queries using spwho2 and spwhoisactive which has high logical reads and high cpu usage and then you can kill particular process.

    commented on Nov 21 2011 5:58AM
    Hiren K
    539 · 0% · 68
  • I suppose you are referring to "Dedicated Administrator Connection (DAC)" and therefore I edited the title of the post to resemble that. Dedicated Administrator Connection is something that should be used with great care, because when connecting with DAC, you can access a number of internal tables.

    When connecting from SSMS, you can enter the server name as "ADMIN:servername" to connect using the Dedicated Administrator Connection. This MSDN article provides more information.

    commented on Nov 21 2011 6:53AM
    Jacob Sebastian
    1 · 100% · 32004
  • Incomplete article written in barely-comprehensible broken English. Can an admin nuke this please?

    commented on Nov 22 2011 3:46AM
    jon.g.massey
    1151 · 0% · 22
  • So, I edited the post, changed the title and completely rephrased the content. Anyone would like to enhance it further?

    commented on Nov 22 2011 7:37AM
    Jacob Sebastian
    1 · 100% · 32004

Your Comment


Sign Up or Login to post a comment.

"Dedicated Administrator Connection (DAC) can be used to troubleshoot an unresponsive SQL Server Instance" rated 5 out of 5 by 5 readers
Dedicated Administrator Connection (DAC) can be used to troubleshoot an unresponsive SQL Server Instance , 5.0 out of 5 based on 5 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]