If you look at the term priority boost, you may think this feature may be related to improving the SQL Server Performance but I can tell you confidently from my experience of Comprehensive Database Performance Health Check that honestly instead of enabling when I disable it, we get necessary performance.
Here is the official Microsoft documentation which describes that the Priority Boost feature will be not supported in the future and it is a good idea to disable it on the server. Microsoft documentation also suggestions that we should not use this feature in the future as well.
In this SQL in the Sixty Seconds video, we discuss how we can check the current status of the configuration and how we can disable priority boost for our server.
If you are looking for the script used in this demonstration, you can easily find them over in the following blog posts.
- SQL SERVER – Turning Off Priority Boost Server Configuration Option on SSMS 18 Onwards
- SQL SERVER – Priority Boost and SSMS 18
- SQL SERVER – Boost SQL Server Priority and SSMS 18
Reference: Pinal Dave (https://blog.sqlauthority.com)
