Your ASP.NET application uses connection pooling to connect to a database. You find that the following exception is logged repeatedly after the application runs for a few hours:
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.
Once this exception occurs, the application is no longer able to connect to the database. You find that when you restart the application, it can connect again for a few hours. You must fix the problem and make sure that it no longer occurs.

What should you do?

 Posted by Rajkatie on 8/31/2012 | Category: ADO.NET Interview questions | Views: 2533 | Points: 40
Select from following answers:
  1. Ensure that your application closes all database connections correctly and consistently.
  2. Ensure that the database is online.
  3. Increase the connection timeout.
  4. All Above

Show Correct Answer


Source: MeasureUp.com | | Alert Moderator 

Comments or Responses

Login to post response