Best Value for Maximum Worker Threads - SQL in Sixty Seconds 170

Опубликовано: 22 Октябрь 2024
на канале: Pinal Dave
3,544
137

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