O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

priority boost

Type: Advanced

Default value: 0

The priority boost option is used to specify the process priority of SQL Server processes on the Windows operating system. The default value of 0 means that SQL Server should run on the same priority level—a priority base of 7—as other applications on the machine. This option can be turned on if you have plenty of horsepower to deal with all other services on the box, as in a multiprocessor environment. When you turn on priority boost, the priority base of SQL Server is elevated to 13.

The following is an example of this option:

exec sp_configure 'priority boost', 1goRECONFIGUREgo

Note

You shouldn’t set the value of the priority boost parameter to 1 except in the case ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required