December 2013
Intermediate to advanced
1872 pages
153h 31m
English
book
Microsoft® SQL Server 2012 Unleashed
by Ray Rankins, Paul T. Bertucci, Chris Gallelli, Alex T. Silverstein
Content preview from Microsoft® SQL Server 2012 UnleashedBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
user connections
Type: Advanced, self-configuring
Default value: 0
The 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. ...