TechNet
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize
This documentation is archived and is not being maintained.

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. 

  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.

Show:
© 2016 Microsoft