Quick Scan Report – Priority Boost

This is a dangerous SQL Server setting to enable. You would think that with a name like Priority Boost that this would be the secret SQL Server turbo button, but no its not.
In most cases this will negatively impact the performance on your SQL Server and should not be enabled.

Note the following warning form Microsoft Books Online

  • Raising the priority too high may drain resources from essential operating system and network functions, resulting in problems shutting down SQL Server or using other operating system tasks on the server.

Don’t use this.


Enroll Today!
SteveStedman5
SteveStedman5
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!