Open the Object Explorer, connect to the instance, right click on the instance, select "reports", follow your nose. If the server is so locked up that doesn't work, then you can try something like the query that Ed posted above.
This should also serve as a warning that you need to spend some time preparing for when the next time this happens. Don't put it off. Do it right after you get through this problem.
--Jeff Moden
Change is inevitable... Change for the better is not.