Solved

Application Pools, Pooling=false & Best practice

Posted on 2012-03-11
4
562 Views
Last Modified: 2012-04-15
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 ...
0
Comment
Question by:lawso
  • 2
4 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 37709997
Youv'e read lots. In order to help we need to know what youv'e done. Not that you searched and read alot.

Thos said, roll up your sleeves case well probably get dirty.

Have you
Examined the SQL Errorlog
Examined event logs application and system
Examined IIS logs

Run performance monitor to capture OS Health
Run profiler to see whats going on in the sql.

What languages does the web use, is it a third party application (name if youre allowed to share that information), or something being developed by your firm/consultants.

Do you have any suspicious thoughts, has the application ever worked. When did it stop performing. Was there any upgrades in the application, MS patches or Servicepacks?

Please provide as much onformation you can.

Regards Marten
0
 
LVL 51

Expert Comment

by:Ted Bouskill
ID: 37712987
OK, you are using the wrong strategy for managing the SQL connection especially when using ADO.NET and the SQL .NET provider.

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.
0
 

Author Comment

by:lawso
ID: 37763565
OK thanks guys

I will check all of this information and post back soon.
0
 
LVL 20

Expert Comment

by:Marten Rune
ID: 37826609
Hows it going, need further assistance or is it solved?

regards Marten
0

Featured Post

The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
A phishing scam that claims a recipient’s credit card details have been “suspended” is the latest trend in spoof emails.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how the fundamental information of how to create a table.

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question