How to look at what is going on in a pegged SQL Server instance?
I have a SQL Server instance that is pegging out my server. I'd like to look at what jobs are running, but it's so slammed that I can't even log in.
Is there some secret way to get in and look at whats running when the server is slammed or do I just need to yank the plug out of the wall?
UPDATE: I tried connecting using DAC but it threw this error message:
Try the Dedicated Administrator Connection (DAC).