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:
These systems may see a slight increase in performance by setting the lightweight pooling value to 1.