In How It Works: SQL Server 2012 Database Engine Task Scheduling, Bob Dorr explains some of the changes for worker scheduler assignment in SQL Server 2012. He mentions that some of the improvements are only available in enterprise edition. Do these differences persist in SQL Server 2019?

If it matters, I'm asking because I'm seeing possible scheduler inefficiencies on a SQL Server 2017 standard edition instance which has a planned future upgrade to enterprise edition. I don't want to attempt an investigation on standard edition if it's possible that upgrading to enterprise will resolve the issue.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.