Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2011-09-06
1
Medium Priority
?
290 Views
Last Modified: 2012-08-14
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
Comment
Question by:Anthony Matovu
1 Comment
 
LVL 5

Accepted Solution

by:
zvytas earned 2000 total points
ID: 36493623
Yes, this is a widely used approach - open connection on page load and close id on page unload.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Suggested Courses

877 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question