Re: How much should I need to Dispose() of
From: David Browne (meat_at_hotmail.com)
Date: 06/09/04
- Next message: Brian Perch: "System.ArgumentException: These columns don't currently have unique values"
- Previous message: chris: "Update sql server table with dataset from xls file"
- In reply to: William \(Bill\) Vaughn: "Re: How much should I need to Dispose() of"
- Next in thread: Dmitri Khanine: "Re: How much should I need to Dispose() of"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 9 Jun 2004 10:10:43 -0500
"William (Bill) Vaughn" <billvaRemoveThis@nwlink.com> wrote in message
news:e5YTzCdTEHA.556@tk2msftngp13.phx.gbl...
> Dispose won't help if the connection is orphaned or still in use.
> Connection pool timeouts are caused by one thing: the connection pool is
> full. Why does the pool fill when it gets to 100 connections when 5 should
> be enough for a healthy system? Generally, there's two reasons:
> 1) The connection was not done in time to be reused by the next
request.
> To compute this, divide the available bandwidth of the system (its
> processing power) by the demand. Suppose your ASP page takes 5 seconds to
> service a query. This means it can handle about 12 hits/minute per
> connection. If you have 120 hits/minute you're going to exhaust the
capacity
> of the system and your pool will overflow. The solution to this problem is
> either improve the hardware performance or decrease the length of time
each
> ASP takes to do its job.
In practice ASP will generally not allow that many simultaneous requests to
execute. The exact mechanism is obscure, but requests should start queuing
before you run out of connections. If this does happen, the solution is to
properly configure the ASP worker thread pool. If all your ASP pages
require DB access, you should never allow more ASP worker threads than
available connections.
David
- Next message: Brian Perch: "System.ArgumentException: These columns don't currently have unique values"
- Previous message: chris: "Update sql server table with dataset from xls file"
- In reply to: William \(Bill\) Vaughn: "Re: How much should I need to Dispose() of"
- Next in thread: Dmitri Khanine: "Re: How much should I need to Dispose() of"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
