Today we will learn about Best Value for Maximum Worker Threads.
Subscribe for Free Performance Tuning Scripts: https://go.sqlauthority.com/
Query used in blog:
SELECT cpu_count, max_workers_count
FROM sys.dm_os_sys_info
0:00 Intro
0:17 Real World Scenario
0:35 Query
0:55 Algorithm
1:10 A Common Question
1:29 Summary
#SQLServer #PerformanceTuning #SQLAuthority