Introduction

Lightweight pooling, also known as fiber mode, is a configuration option in SQL Server designed to reduce the overhead caused by excessive context switching in symmetric multiprocessing (SMP) environments. Context switching occurs when the operating system switches between threads, which can be resource-intensive. By using fibers (lightweight threads), SQL Server can perform context switching inline, reducing the need for user/kernel mode transitions.

Problem

Change lightweight pooling configuration

Solution

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