Export (0) Print
Expand All
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft