We have a web application that is causing dramas at the moment and we are trying to get to the bottom of it. Any help would be greatly appreciated.
The Server is Windows 2003 SBS running IIS6
We have created a Dedicated Application Pool for the Web App
We set and open 1 connection in the Global.asax in the Session_Start
This connection is used for creating Datatables, Sending Insert,Update,Delete SQL Strings to the database, creating Datasources for Telerik Radgrids
Everything we create, we dispose of.
After about an hour the application falls over. We recycle the App Pool and it all starts working again.
We would love some advice on how we can get to the bottom of this. Having read just about everything out there on this ...