When is a connection pool entry established?
a. When you open a connection to the database. If there is a matching connection string in the connection pool, it will draw on it. Otherwise, it will create a new one (and establish the minimum pool size entries).
True or false: Connection pooling is automatically turned off for .NET.
False. In .NET, connection pooling is on as the default ( pooling = "true" ).
What must you do every time in coding to make sure that you and others can take advantage of the connection pool in subsequent processing?
c. Close the connection to the database. This will release the connection back to the connection pool for subsequent use. If you do not explicitly close the connection, it will not be available to use.
What must match exactly for the application to draw on an already established connection pool entry?
a. The entire connection string. Even the smallest difference in the coding of a conceptually equivalent connection string will cause it not to match an entry in the connection spool.
What performance object can you use to monitor usage of connection pooling?
d. .NET CLR Data ”performance object and its associated pool connection counters.