Using the lightweight pooling Option
The overhead of switching thread contexts is not very large. Most instances of Microsoft® SQL Server™ will not see any performance difference between setting the lightweight pooling option to 0 or 1. The only instances likely to benefit from lightweight pooling are those running on a computer characterized as:
- A large multi-CPU server.
- All of the CPUs are running near maximum capacity.
- There is a high level of context switching.
These systems may see a slight increase in performance by setting the lightweight pooling value to 1.