Results 1 to 9 of 9
  1. #1
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322

    Unanswered: max connections?

    Ok, yeah, I'm being lazy...

    Any comments?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Geseundheit ?

    -PatP

  3. #3
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Thank you...Thank you very much....

    x002548 has left the building.....
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  4. #4
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Originally posted by Pat Phelan
    Geseundheit ?

    -PatP
    We will be amused if you can explicate in english.... in advance.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Originally posted by Satya
    We will be amused if you can explicate in english.... in advance.
    There is an enormous amount of rather obscure humor in this thread.

    Brett's original post made about as much sense to me as a sneeze. Max connections of what to what? Me to the red head at the bar, max connections equals zero.

    I responded with a German word/phrase that is the courteous response to a sneeze. I hoped to provoke a bit more explanation of what Brett meant.

    Brett apparently picked my response as a reference to an old Elvis Pressley movie scene. He then carried that reference further.

    Like I said, the whole thread is rather obscure. I found it funny, YMMV.

    -PatP

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578

    Talking

    Great.... thanks for the meticulous explanation... a part of Friday funnies.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ok...ok....

    a server allows connections, yes?

    We use connection pooling...you can set the min and max that it will manage...

    Is there an upper limit of connections allowed by the server or before performance degrades?

    Or am I phrasing this totally wrong?

    Is it 5:00 yet?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  8. #8
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Well, its not 17:00 for you, but for me it is.... so in jovial mood

    Then coming to original point :
    Max Pool Size keyword is to determine how many connections the pool will hold.

    By default, the Data Provider permits 100 connections to accumulate in each pool. This doesn't mean that you start with 100 SqlConnection objects or 100 connections, only that you can't create more than 100 connections per pool.

    If you try to exceed the maximum limit you've set, your application will wait until you pass the ConnectionTimeout limit or until a connection becomes available in the pool, then raise an exception. Max Pool Size doesn't limit the number of pools you can create—that limit is determined by the number of SQL Server connections that your sa setting or license makes available (about 32,768 per cluster).
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  9. #9
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Originally posted by Brett Kaiser
    a server allows connections, yes?
    If properly configured, yes.
    Originally posted by Brett Kaiser
    We use connection pooling...you can set the min and max that it will manage...

    Is there an upper limit of connections allowed by the server or before performance degrades?
    Yes. The connection pooling is typically done on the "client" side of the connection, although it can be done on both sides.

    In general, you want to have enough "idle" connections to service any resonable load of connection requests. This is usually between 2-5% (rounded up) of your pooled connections idle. This can vary considerably in "spikey" usage situations.

    Connection pooling allows near instant initiation of new connections, but it can waste unnecessary resources if misused.
    Originally posted by Brett Kaiser
    Is it 5:00 yet?
    Somewhere! Probably about Munich by now.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •