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

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/default.asp?url=/library/en-us/architec/8_ar_sa_0w6d.asp?frame=true
Fiber mode is specifically discussed in this topic:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_9m9f.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

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

FastLoad OLEDB Destination with Oralce

Hi,

why Table or View – fast load option in Data Access mode is not listed when we connect Oracle Database in the OLEDB Destination.

Thanks

Jegan

When you switch data sources using an OLE DB destination, you are most probably using a different kind and version of the OLE DB provider. I'm guessing that in your case, you are using Microsoft's Oracle OLE DB provider? that `-fast load` option is a feature of the underlying OLE DB Provider, which in your case, I'm guessing is Microsoft's OLE DB provider (SQL Native Client). And that is probably not a feature of the underlying OLE DB Provider for Oracle that you are using, and thus, do not show-up as an option.

|||Thanks Deniz.