Purpose

The purpose of this article is to teach you the process of setting up the priority boost option in Microsoft SQL Server 2000.

To Set the Priority Boost Option

Priority boost option is used to specify whether Microsoft SQL Server should run at a higher Microsoft Windows NT 4.0 or Windows 2000 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 NT 4.0 or Windows 2000 scheduler. The default is 0, which is a priority base of 7. Priority Boost should be used only on a computer dedicated to SQL Server, and with a symmetric multiprocessor (SMP) configuration.

Follow the steps below to set up the priority boot option:

1. Click Start, go to Programs, then go to Microsoft SQL Server, and click Enterprise Manager.

2. Right click the registered SQL Server i.e. PC54, click Processor tab.

3. Select the Boost SQL Server priority on Windows option.

4. Click OK.