Select from following answers:- Periodically call SqlConnection.ClearAllPools from an administrative application.
- Call SqlConnection.ClearPool each time you close the connection.
- Apply a short Connection Timeout setting to the connection strings.
- All Above
The SqlConnection.ClearAllPools method empties the connection pool associated with the specified connection. Calling this method strategically and periodically lessens pool fragmentation.
Connection Timeout sets the length of time (in seconds) to wait for a connection to the server before terminating the attempt and generating an error. Modifying this value does not solve the problem.
Show Correct Answer
Source: MeasureUp.com | |
Alert Moderator