CPU related

I have +4 CPU do i have to enable Use windows NT Fibers.
from
DollerRequired to, no. May benefit from, yes. On a dedicated SQL server you
should boot priority and enable fibers after testing. If this server is not
dedicated to SQL Server then you will run the risk of throttling the other
services on the server.
burt_king@.yahoo.com
"doller" wrote:
> I have +4 CPU do i have to enable Use windows NT Fibers.
> from
> Doller
>|||burt_king wrote:
> Required to, no. May benefit from, yes. On a dedicated SQL server
> you should boot priority and enable fibers after testing. If this
> server is not dedicated to SQL Server then you will run the risk of
> throttling the other services on the server.
>
>> I have +4 CPU do i have to enable Use windows NT Fibers.
>> from
>> Doller
The general recommendation with "boost priority" is not to use it ever.
Even on dedicated servers, I have not read any reports that it actually
helps performance and have a many items in the past that talk about
problems. My understanding is that "NT Fibers" might show a small
performance boost if you're server is experiencing a lot of context
switching.
My general recommendation is to leave those two options alone and look
for other places to boost performance like your SQL, disk subsystems,
and physical database layout including your backup location.
David Gugick
Quest Software
www.imceda.com
www.quest.com|||Dear David,
As we had faced lot of performance problem last year so we have enabled
the fibre switch and it helped us.But the problem rasied is that we
canot create jobs and cant even execute them.
I searched a lot about this bug and forund a topic on microsoft web
site .They say to disable fibre option .After disabling the fibre
option we restart the services then our job workes fine.
but we can't use Windows NT fiber option.
Is windows NT fibers related to jobs.
from
Doller