Results 1 to 3 of 3

Thread: Number of users

  1. #1
    Join Date
    May 2003

    Unanswered: Number of users

    Quick question, is there a limitation on the number of users that can get into SQL server at one time? Say 1500 or 2000 users? If not, I wonder how many users can actually cause the performance of the server to have a significant drop.



  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    There is a pretty hard limit at 32000 users, but I think it could be broken given sufficient hardware. I'm not sure that it makes any sense to even go there, other than as an academic exercise because it smacks of poor system design. A federated replicated approach allows practically infinite growth from an application perspective.

    Most servers will crunch LONG before you even begin to approach the limits of the database engine. The number of supportable users usually depends on the RAM use more than anything, although the I/O bus often factors into that decision too.


  3. #3
    Join Date
    Nov 2002
    Are you talking about connections or users?

    You should keep your transactions short AND your connections as few as possible....

    Get in Get out...

    I use connection pooling, and even though I may have thousands of users, I'll only up a set number of connections..that stay open...for connection pooling purposes....

    Why do you ask?

    Sounds like a web app

    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.

Posting Permissions

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