Fiber Mode

Hi...can someone explain to me what fiber mode is, and how can I tell if my
instance of SQL Server is running in fiber mode
Thanks.An instance of the database engine is in fiber mode if the option
lightweight pooling is set to 1. You can see the setting of that option
using sp_configure or Enterprise Manager. It is an advanced option, so you
have to have the sp_configure show advanced options setting turned on.
There are a set of topics in the SQL Server 2000 Books Online that discuss
how the database engine uses Windows threads and fibers under this node:
http://msdn.microsoft.com/library/d...asp?frame=true
Fiber mode is specifically discussed in this topic:
http://msdn.microsoft.com/library/d...asp?frame=true
Most instances of the database engine are not run in fiber mode, most of the
time the instance runs fine without using fibers.
Alan Brewer [MSFT]
Lead programming Writer
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights