Blog Post

SQL Server Blog
5 MIN READ

SQL Server 2019 Intelligent Performance -Worker Migration

dongcao's avatar
dongcao
Icon for Microsoft rankMicrosoft
Oct 23, 2019
        SQL Server task scheduling basics   A few basic terms: Scheduler – each scheduler is mapped to an individual logical processor (DMV sys.dm_os_schedulers) Worker – each wo...
Updated Oct 23, 2019
Version 1.0
SQLServerAlwaysOn
SQLServerTiger
MihailP's avatar
MihailP
Copper Contributor
Aug 01, 2024

Hi dongcao ,

Thank you for explanation of worker migration process in SQL Server 2019.

Can you please let us know if there were any updates in SQL 2022 and more processes were enabled for migration between schedulers?