Back in 2005, we hired a vendor create an app for us to take
in document submissions. We have two servers to do this, both Win
2003 servers running Coldfusion MX 6.1 and IIS. Network Load
Balancing was set up to include both, so when someone goes to
docs.mycompany.com, they'd go to either docs1.mycompany.com or
docs2.mycompany.com. Both servers connect to an MS SQL server. NLB
is using Single Affinity sticky sessions.
This setup has worked with no problems since it was first set
up in 2005 until a couple of weeks ago. Now, docs1.mycompany.com
will "hang" and then give a database query error. The
application.cfm file has a query in it to read some settings. The
other server, docs2.mycompany.com has no problem. As far as I can
tell, the docs1 server will do this after a period of inactivity.
If it does this, and I open up my web browser, and type in the
direct url,
http://docs1.mycompany.com,
then the opening page comes up fine. After I do this, going to
http://docs.mycompany.com
comes up normally again.
I'm not aware of anything changing on this server. Like I
said before, everything had been working fine since 2005. Does
anything have any ideas as to what could be going on?