We have had several recent production issues with our SQL 2008 database where so many queries stacked up that we ran out of threads and sql was unresponsive. We are having a tough time diagnosing the issue since Idera could not connect. We couldn't tell via any of the views what led up to the issue. Any ideas here? We are on version 9.1. Are newer editions better? Also, we tried at one point turning on the query analyis feature but this at one point took down the sql server. Has anyone had luck with that in the newer versions?
There is a thing called "Dedicated Admin Connection". With this kind of connection (only one per instance) you will be able to connect from Management Studio, even if all worker threads are occupied, because it runs in its own scheduler. At least you can do some basic troubleshooting then, if it was only to save the current session information to a DBA database for later analysis.
Another option would be to create a custom counter in SQLdm called "spare workers"