English 中文(简体)
Connection Pooling and Multiple Connection Strings
原标题:

An ASP.NET 3.5 application has two connection strings:

Data Source=RedDB;Initial Catalog=Red;User Id=myuser;Password=pas;Max Pool Size=50;Min Pool Size=1

Data Source=BlueDB;Initial Catalog=Blue; User Id=myuser;Password=pas;Max Pool Size=375;Min Pool Size=2

Suppose the RedDB connection has a stored procedure that is hanging indefinitely due to a bad index.

  1. If the application does not close the RedDB connection properly (viz., with a try/finally block), how quickly do the pool connections get recycled as users are hitting the site?

  2. If the RedDB connection pool is maxed out because of users getting the SQL timeout, does that have ANY impact on the BlueDB, or is that a completely isolated connection pool?

最佳回答

If the connection is not properly disposed, you re at the mercy of the GC. And you never know when it is going to kick in (even if you call GC.Collect() it is not guaranteed that a given object will be collected).

Connection pools are based on connection strings, so those 2 connections strings that you have will create 2 completely separated pools.

问题回答

暂无回答




相关问题
Anyone feel like passing it forward?

I m the only developer in my company, and am getting along well as an autodidact, but I know I m missing out on the education one gets from working with and having code reviewed by more senior devs. ...

How to Add script codes before the </body> tag ASP.NET

Heres the problem, In Masterpage, the google analytics code were pasted before the end of body tag. In ASPX page, I need to generate a script (google addItem tracker) using codebehind ClientScript ...

Transaction handling with TransactionScope

I am implementing Transaction using TransactionScope with the help this MSDN article http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx I just want to confirm that is ...

System.Web.Mvc.Controller Initialize

i have the following base controller... public class BaseController : Controller { protected override void Initialize(System.Web.Routing.RequestContext requestContext) { if (...

Microsoft.Contracts namespace

For what it is necessary Microsoft.Contracts namespace in asp.net? I mean, in what cases I could write using Microsoft.Contracts;?

Separator line in ASP.NET

I d like to add a simple separator line in an aspx web form. Does anyone know how? It sounds easy enough, but still I can t manage to find how to do it.. 10x!

热门标签