We have a Web Application setup using ASP pages connecting to a MS SQL
7.0 database. Recently, we moved the system to a new set of servers
(one for the web, one for the db). After the move we are seeing a
very strange and annoying problem outlined below (which we did NOT see
on the old servers or in our test environment).
Both servers are running along fine for a while (30-60 minutes), then
the response time from the db drops to almost nothing. ASP pages take
forever to return if they do not timeout. Both the DB and Web server
show almost no noticeable CPU and Memory usage above normal idle
amounts. The DB is not waiting on any locks to resolve or anything
like that. Traffic on the Web Server is minimal (approx 200-250
current sessions). So, from all appearances, both servers are not
experiencing any signifcant load, yet the performance would suggest
Restarting IIS on the Web server will alleviate the slowness for
another 30-60 minutes.
Any body out there ever experience anything similar? Or, does anybody
have any suggestions for us to try?