Your ASP.NET application uses connection pooling to connect to a database. You find that the following exception is logged when the application is under heavy load:
Exception: System.InvalidOperationException
Message: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
You must fix the problem without causing undue overhead to build connections.

What should you do?

 Posted by Rajkatie on 8/31/2012 | Category: ADO.NET Interview questions | Views: 1236 | Points: 40
Select from following answers:
  1. Increase the size of the connection pool or increase the connection timeout.
  2. Ensure that the database is online.
  3. Disable connection pooling.
  4. All Above

Show Correct Answer

Source: | | Alert Moderator 

Comments or Responses

Login to post response