Hi,
I have been running a app server off of a networked SQL 7 server for
several years now. It has been working flawlessly. In the past several
months a problem has started recurring. About every third or forth
weekend the app server will drop its connection to the SQL Server and
the app server will then fail. I can't tell if the weekend timing has
anything to do with it, other than coincidence. Traffic is much lower
during the weekend and the day (Saturday vs. Sunday) or time is not
fixed.
I am stuck. What could be ausing the problem? I can guess that it
could be a faulty NIC on the app server, since other app servers running
against the same database server are not affected. Any clues or ideas
how I can track this down? Monday mornings are bad enough!
Thanks,
Mr. XML