Solved

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

Posted on 2007-11-28
3
180 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 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
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…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

708 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now