What is the fundamental meaning of max worker threads in SQL server?

Posted on

Question :

I’m using sql 2019 on 8cpu machine, and as per this link (https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-max-worker-threads-server-configuration-option?view=sql-server-ver15#Recommendations) the default number of max worker threads are:576

What does this number signify?

For example – assuming max DOP is 1 (no parallelism), does this mean that the SQL server will support query request from 576 clients concurrently?

Answer :

What is the fundamental meaning of max worker threads in SQL server?

It means what it states, this is the (soft) maximum number of threads that SQL Server will create and use.

For example – assuming max DOP is 1 (no parallelism), does this mean that the SQL server will support query request from 576 clients concurrently?

It encompasses all threads, not just those that run queries.

Leave a Reply

Your email address will not be published. Required fields are marked *