Type: Advanced, self-configuring
user connections option specifies the number of concurrent users allowed on SQL Server. When the value is
0 (which is the default), SQL Server can configure the needed user connections dynamically as they are needed (unlimited). If you specify a value, you are limited to that maximum number of user connections until you specify a larger value. If you specify a value other than
0, the memory allocation for user connections is allocated at SQL Server startup time, and it burns up portions of the memory pool. Each connection takes up 40KB of memory space. For instance, if you configure SQL Server for 100 connections, SQL Server pre-allocates 4MB (40KB ¥ 100) for user connections. ...