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

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
LVL 1
Anthony MatovuBusiness Analyst, MTN UgandaAsked:
Who is Participating?
 
zvytasConnect With a Mentor Commented:
Yes, this is a widely used approach - open connection on page load and close id on page unload.
0
All Courses

From novice to tech pro — start learning today.