Regardng Connection Pooling

Question

Where is the connection pool created i.e on the client side or on the server side?

If it is created on the client side then how multiple clients interacting with a single server are able to make use of the pool??

TIA :)

 

Regards,

Vikas

---

Kind Regards, Vikas

Answer 1

Hello,

Thank you for posting.

A connection pool is created for each unique connection string. So  connections are added to the pool as needed, up to the maximum pool size specified (100 is the default).

Please check this document for more information about Connections Pooling. http://msdn.microsoft.com/en-us/library/8xx3tyca.aspx

Best Regards,

---

Larcolais Gong[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

Dear Larcolais,

Thanks for your reply, but still I was unable to find where exactly is the connection pool maintained - the client or the server side ??

Kind Regards,

Vikas

---

Kind Regards, Vikas

Answer 3

Dear Larcolais,

Thanks for your reply, but still I was unable to find where exactly is the connection pool maintained - the client or the server side ??

Kind Regards,

Vikas

---

Kind Regards, Vikas

Hello again,

ADO.NET doesn't always create a connection pooling on the IIS server or SQL Server etc. even if you're connecting from a remote system. Typically, it creats pools on the system where the ADO.NET code runs. Please check this document for more detailed information about .NET Connection Pool Lifegurad. http://msdn.microsoft.com/en-us/library/aa175863(v=SQL.80).aspx

Best Regards,

---

Larcolais Gong[MSFT]
MSDN Community Support | Feedback to us
Get or Request Code Sample from Microsoft
Please remember to mark the replies as answers if they help and unmark them if they provide no help.