How to: Configure the priority boost Option (SQL Server Management Studio)

Use the priority boost option to specify whether Microsoft SQL Server should run at a higher Microsoft Windows 2000, Windows 2003, Windows 2008, or Windows 2008R2 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 2000, Windows 2003, Windows 2008, or Windows 2008R2 scheduler. The default is 0, which is a priority base of 7. 

Important noteImportant

This feature will be removed in a future version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

To set the priority boost option

  1. In Object Explorer, right-click a server and select Properties.

  2. Click the Processors node.

  3. Under Threads, select the Boost SQL Server priority check box.

  4. Stop and restart SQL Server.

Community Additions