Technical-Talk banner
Home   About Us   Contact Us
Question:

You are the ASP.NET developer and developed an application in ASP.NET which uses Microsoft SQL server .NET data provider to connect to the database. Your application will be used by several users, due to the heavy usage of the application data requests are being blocked until the new connections to be created. You want to improve throughput by setting a minimum connection pool size of 15, what should you do?
A. Add a connection element under an appSettings element in the Web.config file for your application, and specify a minimum size of 15 for the connection pool.
B. Add a Min Pool Size property to the connection string you use when opening a connection, and specify a minimum size of 15 for the connection pool.
C. Add a connection element under an appSettings element in the Machine.config file on your Web server, and specify a minimum size of 15 for the connection pool.
D. Add a Min Pool Size property to your ADO.NET connection objects, and assign a value of 15 to the property.




Correct Answer:
B
Explanation:
The Min Pool Size property of the connection string specifies the minimum number of connections maintained in the pool. Incorrect Answers
A, C: The Minimum pool size should be configured in the connection string, not in the appSettings settings.
D: Min Pool Size is not a property of a connection object. It is an attribute in the connection string.

Google