'SQL Server Connection Limit

What is the concurrent connection limit of SQL Server?

In the microsoft docs ,it is saying "SQL Server allows a maximum of 32,767 user connections.". Should we think that value as per SQL Server instance? I mean Let's say we are using SQL Server high availability like the structure in high availability. Then we will have had multi SQL Server instances. One of them must be master instance and rest of them are slave instances.

Then shortly;

  1. Does 32,767 mean connection limit per instance?
  2. If so; Let's say we have 1 master instance and 3 slave replica instances in our SQL Server High Availability?

1 * 32,767 + 3 * 32,767 = 137,068

Then will our max connection limit be 137,068?

sql-server


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions