O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required