Boost SQL Priority

The Boost SQL Priority option in SQL Server allows the database engine to run at a higher scheduling priority than other processes on the same server. When enabled (set to 1), SQL Server runs at a priority base of 13 in the Windows scheduler, compared to the default priority base of 7. This can potentially cause other system processes, such as networking and operating system functions, to have insufficient resources, which may lead to performance issues or even a system shutdown.

Why It's Important to Disable Boost SQL Priority

  • Resource Contention: Enabling Boost SQL Priority can cause SQL Server to consume resources that are critical for other processes, potentially leading to system instability.
  • System Performance: Raising SQL Server's priority too high can starve the operating system of essential resources, impacting overall system performance.
  • Best Practice: Microsoft generally recommends leaving Boost SQL Priority disabled (the default setting).

Suggested Action

It is recommended to disable Boost SQL Priority to ensure that SQL Server runs without interfering with other critical processes on the server. SQL Server performance can usually be optimized through proper resource allocation and hardware scaling without needing to enable this option.

How to 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

How Aireforge Detects Boost SQL Priority

Aireforge automatically checks if Boost SQL Priority is enabled and flags the instance if the setting is configured to run at an elevated priority. It provides a recommended fix to disable this option for optimal system stability and performance.