December 9, 2004 at 3:23 pm
What is the Maximum number of concurrent users that can log into SQL Server 2000? SP3.
December 9, 2004 at 3:27 pm
One of my developer set his connection pool to 1000. On top of this we have a lots of developer doing other works.
mom
December 9, 2004 at 3:29 pm
Thank you for the so-fast reply : ).
Can you tell me how I check my connection pool setting?
December 9, 2004 at 5:56 pm
I don't recall an specific never every being dropped. I have heard as high as 50,000 connections on a server before in major centers. It is all based on the number of transacrions you can process during a given period of time and hardware (IO, Memory and Network).
December 10, 2004 at 6:21 pm
There is a tab for connection pooling under ODBC administrator.
Check this article for more information about connection pooling
December 10, 2004 at 6:53 pm
Connection pooling has nothing to do with number of connections it has to do with the reuse of connection and is a client side thing, not server.
December 11, 2004 at 9:10 am
Antares,
I agree with you.Connection pooling has nothing to do with no. of connection and can be used for fine tuning your performance. The answer which i gave was reference to the below and i understood that you had already answered his original question. Sorry for any confusion.
"Can you tell me how I check my connection pool setting?"
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply