SQL Server Connection Pool and Connection String Parameters
Posted on 2007-10-01
I'm learning about SQL Server Connection Pooling and Connection String Paramenters.
I have som questions about the following paramenters:
1) Connection Reset Parameter
a) It is saying in my book that it determines whether the databse connection is reset when it is removed from the pool and that when it is set to False, it prevents an additional server round-trip when obtainng a connection. What it means? Can you please give me a real world example?
b) It is saying here that I must be aware that the connection state is not being reset in the above context. What it means?
c) It is saying to use the ChangeDatabase method rather than the SQL USE command to anable ADO.NET to automatically reset connections whne they are returned to the pool. What is it??? What it means by saying SQL USE command?
2) Enlist Parameter
a) It is saying here that when it is saet to true, the pooler automatically enlists the connection in the current transaction context of the creation thread if a transaction context exists. Could you please give me a real works example of this so I can understand what it means?
3) Min Pool Size Parameter
I would like to know what happen if I set the Min Pool Size parameter to let's say 5 and we have less than 5 active connections. Will the pool be created?