[ASP.NET揭密讀書筆記]串連池

When using SQL connection pooling, you can place additional options in a connection string to modify how connection pooling works. For example, you can specify the minimum and maximum size of the connection pool or even completely disable connection pooling.

Here's a list of the connection pooling options that you can add to the SQL Server connection string:

Connection Lifetime— Destroys a connection after a certain number of seconds. The default value is 0, which indicates that connections should never be destroyed.

Connection Reset— Indicates whether connections should be reset when they are returned to the pool. The default value is true.

Enlist— Indicates whether a connection should be automatically enlisted in the current transaction context. The default value is true.

Max Pool Size— The maximum number of connections allowed in a single connection pool. The default value is 100.

Min Pool Size— The minimum number of connections allowed in a single connection pool. The default value is 0.

Pooling— Determines whether connection pooling is enabled or disabled. The default value is true.