• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 292
  • Last Modified:

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
0
Anthony Matovu
Asked:
Anthony Matovu
1 Solution
 
zvytasCommented:
Yes, this is a widely used approach - open connection on page load and close id on page unload.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now