Hi there
We have a Java application that resides on a Tomcat server and attaches to our SQL Server database.
Every so often the application slows down to a crawl.
We have been monitoring all our services and other counters such as RAM, CPU and page filing and nothing seems out of the ordinary.
Whenever the slow down happens I contact the SQL admin and ask if the system looks good.
He reports that all counters all low and there is nothing on the server that is ringing any bells.
I then ask him to restart the SQL Server and SQL Agent services which he duely does and voila! the application speeds up and starts perfoming properly.
So how is it that there is nothing wrong on the SQL server but restaring the services fixes the problem?
I was wondering if it had something to do with the Tomcat service that connects to the SQL box.
Perhaps there is connection pooling or something that gets reset whenever the SQL services are restarted.
can anyone offer some advice?
Regards
Steven
