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 or Windows 2003 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 or Windows Server 2003 scheduler. The default is 0, which is a priority base of 7. 

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.

See Also

Concepts