Garry Bargsley makes a connection:
Oh no.. my number one troubleshooting tool is not usable. Time to fire up a command prompt and connect via DAC, right?
Well, not so fast.
During a recent technical interview, I was introduced to a clever workaround that lets you connect to a distressed SQL Server using SSMS, even when it seems unresponsive.
Read on to see how you can connect without SSMS performing a bunch of background queries to retrieve data that end up using tempdb, and then resolve the issue.