Boost SQL Priority
Boost SQL Priority is a server configuration option that specifies whether SQL Server should run at a higher scheduling priority than other processes on the same computer. If you set this option to 1, SQL Server runs at a priority base of 13 in the Windows scheduler. The default is 0, which is a priority base of 7.
It’s generally recommended to leave this option disabled because raising the priority too high may drain resources from essential operating system and networking functions, resulting in problems and potentially shutting down SQL Server.
How to Reset or Disable Boost SQL Priority
EXEC sys.sp_configure @configname = N'show advanced options', @configvalue = N'1'; RECONFIGURE; GO EXEC sp_configure 'priority boost', 0; RECONFIGURE WITH OVERRIDE; GO EXEC sys.sp_configure @configname = N'show advanced options', @configvalue = N'0'; RECONFIGURE; GO
Configure the priority boost server configuration option | Microsoft Learn