We have a SQL Server instance that has pegged out a few times in the last few weeks. No one has been able to figure out how to get on and kill processes so they have just been rebooting the server (eek!).
I ended up posting on here in an effort to get access to the server when it's in this state and was directed to the DAC. From what I've read this will allow me to connect the next time it gets pegged (untested as of yet), but I'm wondering if I will be able to do anything once I'm connected or will my queries just time out?