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. ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
