lawso
asked on
Application Pools, Pooling=false & Best practice
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.
Scenario:
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.
Issue
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 ...
Scenario:
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.
Issue
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 ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
OK thanks guys
I will check all of this information and post back soon.
I will check all of this information and post back soon.
Hows it going, need further assistance or is it solved?
regards Marten
regards Marten
Turning off the SQL database pooling is going to kill performance and is likely causing concurrency issues when multiple pages are accessed simultaneously.
SQL connection pooling is a huge performance win and more connections that are setup concurrently and reused the better!
http://msdn.microsoft.com/en-us/library/8xx3tyca(v=vs.80).aspx
The rule of thumb with .NET connections is Open Late/Close Early and allow the connection pooling to do it's job with as few unique connection strings as possible.