Use the lightweight pooling option to provide a means of reducing the system overhead associated with the excessive context switching sometimes seen in SMP environments. When excessive context switching is present, lightweight pooling may provide better throughput by performing the context switching inline, thus helping to reduce user/kernel ring transitions.
Setting lightweight pooling to 1 causes Microsoft® SQL Server™ to switch to fiber mode scheduling. The default value for this option is 0.
lightweight pooling is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change lightweight pooling only when show advanced options is set to 1. The setting takes effect after stopping and restarting the server.
To set the lightweight pooling option
RECONFIGURE | SQL Server Task Scheduling |
Setting Configuration Options | Using the lightweight pooling Options |
sp_configure |