SQL Server Health Check

SQL Server – Priority Boost Option

Updated October 29, 20252 min read

Priority Boost: leave it off. A big red button sits under a clear safety cover latched shut with a small padlock.

What does the priority boost option do?

The option will make SQL Server run the sqlservr.exe process and threads as High Priority.

The priority boost option has the potential to drain resources from essential OS & networking functions, resulting in problems and shutting down SQL Server.

Microsoft's best practices recommend that you do not enable this feature.

How can I check if the priority boost option is enabled?

  1. Using SSMS, right-click the instance name and select Properties.
  2. Then click on the Processors tab.
  3. Ensure the checkbox next to Boost SQL Server priority is not ticked.
Figure 1 - Boost SQL Server priority option
Figure 1 - Boost SQL Server priority option

How do I disable Boost SQL Server priority?

You can disable it using the interface above.

Another way is to implement the change by running the following script:

T-SQL
EXEC sys.sp_configure N'show advanced options'
	,N'1';
GO

RECONFIGURE
GO

EXEC sys.sp_configure N'priority boost'
	,N'0'
GO

RECONFIGURE
GO

More information

Check Red9's SQL Server Services

SQL Server Consulting

Perfect for one-time projects like SQL migrations or upgrades, and short-term fixes such as performance issues or SQL remediation.

Discover More ➜

SQL Server Managed Services

Continuous SQL support, proactive monitoring, and expert DBA help with one predictable monthly fee.

Discover More ➜

Emergency SQL Support

Take the stress out of emergencies with immediate access to a SQL Server Sr. DBA 24x7x365

Discover More ➜

Explore All Services ➜