Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Using the lightweight pooling Option

The overhead involved in switching thread contexts is not very large. Most instances of SQL Server will not see any performance differences between setting the lightweight pooling option to 0 or 1. The only instances of SQL Server that might benefit from lightweight pooling are those that run on a computer having the following characteristics:

  • A large multi-CPU server.
  • All the CPUs are running near maximum capacity.
  • There is a high level of context switching.

These systems may see a small increase in performance if the lightweight pooling value is set to 1.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.