Change server priority boost

Introduction

In SQL Server, Priority Boost is a configuration option that allows the SQL Server process to run at a higher priority level on the operating system. When enabled, it tells the operating system to allocate more CPU resources to SQL Server, potentially improving performance in certain scenarios. However, this feature comes with significant risks and is generally not recommended for most environments.

Problem

Change lightweight pooling configuration

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_priority_boost.sql