locked
How many users from an application can connect to a SQL server at a time? RRS feed

  • Question

  • HI,

        I need to know , How many users from an application can connect to a SQL server at a time? Do we have any settings for this in SQL server for limiting the users?

    Thursday, December 4, 2014 6:55 AM

Answers

  • This is a difficult question, since it is both technical and legal.

    The absolute maximum number of connections is around 32700, but unless your server is very beefy, it will choke long before that. A connection is not a user - an application can have many connections for the same user. Depending on your license model, you may be legally limited to a certain number of users, but this number is not enforced technially.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Thursday, December 4, 2014 10:12 PM
  • The realistic number of simultaneous users will vary based on what's going on in your database. A few users making reports aggregating millions of rows will consume a lot of resources and slow things down. On the other hand, several thousand connections could read or insert small amounts of data every minute. But to have a large amount of throughput, you need to design your data structure well, index it properly, and access it in a way that doesn't cause users to wait for each other. Of course that's why we all have jobs. <g>

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Wednesday, December 10, 2014 4:02 PM

All replies

  • This is a difficult question, since it is both technical and legal.

    The absolute maximum number of connections is around 32700, but unless your server is very beefy, it will choke long before that. A connection is not a user - an application can have many connections for the same user. Depending on your license model, you may be legally limited to a certain number of users, but this number is not enforced technially.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
    Thursday, December 4, 2014 10:12 PM
  • The realistic number of simultaneous users will vary based on what's going on in your database. A few users making reports aggregating millions of rows will consume a lot of resources and slow things down. On the other hand, several thousand connections could read or insert small amounts of data every minute. But to have a large amount of throughput, you need to design your data structure well, index it properly, and access it in a way that doesn't cause users to wait for each other. Of course that's why we all have jobs. <g>

    Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

    Wednesday, December 10, 2014 4:02 PM