After some googling, there seems to not have a straight forward answer to the question. MSDN Forum mentions it depends on CPU, Memory usage, database size etc. Could someone help explain or perhaps suggest an example to show why there are so many factors limiting the number of concurrent connection. Also how could one ever find out the maximum connection of an application?
Sql-server – What determines the maximum number of concurrent connection to SQL Server 2016 Express
connectivitysql serversql-server-2016sql-server-expresswindows 8
Related Question
- SQL Server – Troubleshooting High CPU Usage
- Sql-server – SQL Server 2016 Express: System databases
- Sql-server – SQL Server 2016 Maximum Bytes/Row
- SQL Server 2016 – Troubleshooting Strange Performance Problems
- SQL Server 2016 Enterprise – Poor Performance Issues
- Maximum Concurrent Connections to SQL Server Express 2017 on Windows Server 2016
Best Answer
So are so many factors because there are so many different types of loads. When it get loaded the only defense mechanism is to deny connections.
I you are looking for max connection you are looking for the wrong thing.
Design your application to be scalable - acquire the connection as late as possible and release the connection as soon as possible. A well designed application could have 100 active users and never have more than 10 active connections.