dwilliscp (8/9/2013)
Sorry should have added.. 64bit. Any change that would effect Disaster Recover, has to be done by the App Admin team. So I put in a request, and will see if they make the change. I know when I asked to get worker threads set to 1,000 from the 800 or so that it currently is.. they wanted me to prove that the problems we are having was worker threads. Thus this posting.. on trying to track their use and what happens when they run out.
So you are the DBA, but you don't have permission to connect to the server machine directly? Well, then you have more than one problem!
In the meantime, the persons who have access to the servers, will have to run the diagnostic queries for you.
In this particular case, you should be able to diagnose the issue if the DAC is enabled for remote access. If SQL Server has run out of worker threads, there are of course no threads left for new connections. But there are other problems where you may find that you cannot connect, not over a remote DAC - but where any local connection works. (These problems are known as network problems, but the DBA will get the blame nevertheless.)
/Erland
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]