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

max worker threads

Type: Advanced

Default value: 0

SQL Server uses native operating system threads. The max worker threads parameter specifies the maximum number of threads available for SQL Server processes. One or more threads are used for supporting each network protocol (for example, TCP/IP, named pipes). SQL Server is configured to listen. The checkpoint and lazywriter processes also consume threads. A pool of threads is used to handle user connections. When the number of connections is lower than the max worker threads parameter value, a thread is created for each connection. When more connections are on the server than the value defined by the max worker threads parameter, SQL Server provides thread pooling for efficient resource utilization. ...

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