Remote Web Server & Local SQL Server Communication Problems

[duckweb]

Here is my problem:

We have a local sql server in our data center and a remote web server. When we hit a web page that makes a call to the db server, we get a pretty quick response. However, after we make other calls to the db server, it gets slower and slower, and finally stops the web server from responding to any hits, and we have to reboot the server for it to operate again.

Has anyone experienced this before or have ideas on what to look for? I don't think the problem is on our SqL Server end, but am not sure.

 

[mrdenny]

It sounds like your Web Server is running out of memory. Check your code, are you closing the connections to the database server correctly, on every connection. If not the connections will remain open, and the memory allocated to those connections will remain in use, slowly eating up the memory.

Check the memory usage of the web server every 15-30 minutes on the web server through out a day or two. Is the memory used slowly increasing? If so you've probably got bad code on the web server somewhere.

Denny

--Anything is possible. All it takes is a little research. (Me)