June 12, 2013 at 6:24 am
From time to time our front end application gets 'unable to connect to server: abc' error. The error just goes away on its own. We tried to increase max worker thread, which did not help. Could someone point me to the right direction? FYI, we are on sql 2008 R2 standard.
June 12, 2013 at 6:33 am
First you will have to pin-point the location of the problem. It could be anything from the application server, the network, the database server and/or the instance.
If possible: create every 5 or 10 seconds a connectionto the instance from another (monitoring-)server. If this connection can be made from the monitoring server while the application server can not, you know it's not the database server. When both servers cannot connect at the same time the problem is with the database server.
When you have narrowed the possibilities it's easier to troubleshoot.
June 12, 2013 at 6:39 am
Thanks for the reply.
There is a pool of app servers and there are also db servers connecting to it as well. It is pretty random as to which the server the error happens to. I feel it is the db server. But when I look at the user connection counters, when errors happen, they are not necessarily at the peak. Is there any other counters that I should check?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply