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

x
?
Solved

If I have multiple databases in my SQL Server.  Can some other program effect the connection pool?

Posted on 2007-11-28
3
Medium Priority
?
230 Views
Last Modified: 2010-03-19
If I have multiple databases in my SQL Server.  Can some other program effect the connection pool?

I am sharing a SQL server with multiple databases.  I use Try and Catches when ever I open a connection and dispose of it properly.

On the same server there are other databases, that another program uses.  Can that effect my connection pool?

I get a Timeout, that connection pool max has reached its limits.
0
Comment
Question by:mmedi005
  • 2
3 Comments
 
LVL 18

Accepted Solution

by:
Yveau earned 2000 total points
ID: 20368165
No, when you define a connection pool, that will only be used by the app that defined it. No other app can 'ride' the connection pool. It has to make its own connection(pool) to get access to SQL Server.

Hope this helps ...
0
 

Author Comment

by:mmedi005
ID: 20368529
it does, thanks....
0
 
LVL 18

Expert Comment

by:Yveau
ID: 20368633
Glad I could be of any help and thanks for the grade !
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Problem Hi all,    While many today have fast Internet connection, there are many still who do not, or are connecting through devices with a slower connect, so light web pages and fast load times are still popular.    If your ASP.NET page …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

783 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