Conection Pooling with multiple applications

[ind_123]

Can connection pooling be implemented for multiple applications? How
is it done?

 

[Marc Gravell]

Are you sure about that? I haven't tested it, but most references I've
seen simply state "enabled by default on SQL Server" (or some-such),
without qualifying web vs windows - for example:

http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx

Marc

 

[Arne Vajhøj]

Can connection pooling be implemented for multiple applications? How
is it done?

[I will assume database connections]

Each application has its own pool.

Note that the database will get the sum of all the apps
connections, so consider number of apps when deciding
on pool size.

Arne

 

[Arne Vajhøj]

Are you sure about that? I haven't tested it, but most references I've
seen simply state "enabled by default on SQL Server" (or some-such),
without qualifying web vs windows - for example:

http://msdn2.microsoft.com/en-us/library/8xx3tyca.aspx

It is easy to verify that pooling works for a simple
console app by specifying Min Pool Size and call
sp_who.

Arne

 

[parez]

Can connection pooling be implemented for multiple applications? How
is it done?

I think connection pools are connection string specific.. you will end
up having connection pool for each application(ConnString)