Fiber Mode

I read a lot oabout lightweight pooling but am still
uanble to understand what exactly happens
when "lightweight pooling" is set to 1.
It says SQL server works in fiber mode but what does that
mean and when and how would i decide that i need to set
this option
Thanks
SanjayThis is documented in Books Online. Windows help also provides detailed
explaination on threads and fibers. In short, you're trying to save context
switching with fibers but there are issues invovled. Read BOL and some of
the KB articles on the MSDN/Support site.
aK.
"Sanjay" <sanjayg@.hotmail.com> wrote in message
news:0b6501c39501$ce0eacc0$a001280a@.phx.gbl...
> I read a lot oabout lightweight pooling but am still
> uanble to understand what exactly happens
> when "lightweight pooling" is set to 1.
> It says SQL server works in fiber mode but what does that
> mean and when and how would i decide that i need to set
> this option
> Thanks
> Sanjay|||sqlserver-performance.com mentions a lot about this.
Basically, you are very unlikely to notice any improvement unless your
processors
are context switching @. > 80% for minutes at a time and your processors are
overloaded. This option seems to create more issues than it solves and
should only
be set under controlled conditions, where you know what the gains should be.
"Sanjay" <sanjayg@.hotmail.com> wrote in message
news:0b6501c39501$ce0eacc0$a001280a@.phx.gbl...
> I read a lot oabout lightweight pooling but am still
> uanble to understand what exactly happens
> when "lightweight pooling" is set to 1.
> It says SQL server works in fiber mode but what does that
> mean and when and how would i decide that i need to set
> this option
> Thanks
> Sanjay