August 18, 2010 at 11:57 am
I'm having some kind of connectivity problem between my Windows web servers and my database, and I don't know how to even research it, much less fix it. I have confirmed that a recurring error on my Linux servers is caused when a Windows web server has its "unknown connection problem" to my database. When the connection "problem" occurs, the Windows server stops placing uploads in the network pickup folder but submits the pickup job to the database anyway. The Linux boxes accept the pickup job, go to grab the file on the network, and it's not there. When the problem occurs, it usually happens to multiple web servers simultaneously, and occurring to all of them at once is not uncommon. At worst, the problem has continued for 12+ hours; at best, <30 minutes. The known fix is to restart IIS on the Windows server which closes all the database connections.
So what I want to do is run something from the web servers when we see the errors on the Linux boxes that can hopefully determine which connection to the database from that server is hosed. Any ideas?
August 18, 2010 at 12:50 pm
When you say 'database' is this Linux process even trying to connect to SQL Server or is it just putting files in a folder?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply