I'll start out by saying I am BSA / Web developer being thrown into the deep
end of trying to figure out why our application is all of a sudden hanging.
We have three web servers and one database server dedicated to one ASP vended
application. Two of the web servers were part of the original installation
by the vendor. The application is used throughout the year, but most
heavily from September to February. Because of additional users, we built a
3rd machine just to be safe and put it in the farm a couple months ago.
Everything seemed to be fine until a couple weeks ago when usuage started to
pick up. Two of the web servers now hang over time (usually every few
hours), never usually at the same time, which is resolved by rebooting the
server until it then happens the next time. If you view the performance
monitor, the current connections just starts flying off the charts but if you
look at the database sessions, we may only have a dozen or so at most. The
new web server seems has not yet had an issue. For now, we have drained the
two boxes from the load balancer, allowing the 3rd server to handle all the
traffic. All three boxes are Windows 2000 SP 4. We have uninstalled and
reinstalled the application. We had the vendor walk through their
configuration. Their suggestion ....rebuild the original two boxes. Well,
having to deal with Corporate IT and the paperwork necessary (and all the
darn politics and approvals) to make this happen is not our first choice as
we are in the midst of our most busy time. Is there ANYTHING anyone can
think of that we should look at that might be different between the two boxes
and the new box? There's got to be something but right now it feels like I'm
chasing ghosts....
Thanks in advance for ANY suggestions....