June 26, 2008 at 9:48 am
Our company has 4 main db servers all running either Standard or Express, depending on the server. We create our own C# apps to using to manage certain aspects of the data on the servers. Now we updated one server from Express to Standard, and now we are having Timeouts on the machines in our call center, usually only happening after certain functions are being performed. This is a little difficult due to the fact that our software is the only time it happens. The error comes up in windows, not the software though, and says:
Timeout Expired. The timeout period had elapsed or the server is not responding.
I think this is a connection setting issue in the program, but we think it might be due to some of the replication that we have as well. The main db server copies to the second db server, via subscriptions and publications.
Any thought is helpful.
txtSignature_CommentEmoticon(':)');
🙂
June 26, 2008 at 10:19 am
I'd check and be sure that your statistics and indexes are up to date. Rebuilding indexes will update statistics as well, so I'd do that.
Can you narrow down where the timeouts occur? Certain tables/procs?
June 26, 2008 at 10:48 am
Well, I think so. It only seems to happen when certain functions are ran and then try to complete. I think it's a connection setting in the applications, but we also think it might be something to do with the replication settings since the upgrade/update.
txtSignature_CommentEmoticon(':)');
🙂
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply