issues with connection pool for asp.net and ms-sql server

Anthony Matovu
Anthony Matovu used Ask the Experts™
on
I have had problems with website ms-sql server connection pool getting full and/or timeout expiration. I have done the following.
1. on each page load i open the database
2. at the end of the page load i close the database connection
3. Every time i need to access the database i check if state is closed and i open it depending of the state.
4. On page unload i close the database connection

Do you think this is an efficient approach to my problem
Anthony
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Yes, this is a widely used approach - open connection on page load and close id on page unload.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial