SQL Server Performance Forum – Threads Archive

Has anyone configured Fibers?

Has anyone used Fibers?
I am running a small Dell Server, 1 CPU and memory is maxed.
Would configuring Fibers help me with throughput or would it even slow me down?
I do not know anyone who has activated this option. Much thanks.

Hi ya, The fibers option should almost never be used… You’re best to run SQLProfiler to find the offending statements, as this is almost certainly suboptimal code Cheers
Twan

Hi,
please read some excerpts from BOL :

quote:MicrosoftÂ® WindowsÂ® uses a numeric priority ranging from 1 through 31 (0 is reserved for operating system use) to schedule threads for execution. When several threads are waiting to execute, Windows dispatches the thread with the highest priority. Each instance of Microsoft SQL Serverâ„¢ 2000 defaults to a priority of 7, which is called the normal priority. This gives SQL Server threads a high enough priority to get adequate CPU resources without adversely affecting other applications. The priority boost configuration option can be used to increase the priority of the threads from an instance of SQL Server to 13, which is called high priority. This setting gives SQL Server threads a higher priority than most other applications. Thus, SQL Server threads will tend to be dispatched whenever they are ready to run and will not be preempted by threads from other applications. This can improve performance when a server is running only instances of SQL Server and no other applications. If a memory-intensive operation occurs in SQL Server, however, other applications are not likely to have a high-enough priority to preempt the SQL Server thread. If you are running multiple instances of SQL Server on a computer, and turn on priority boost for only some of the instances, the performance of any instances running at normal priority can be adversely affected. The performance of other applications and components on the server can be degraded if priority boost is turned on, so it should only be used under tightly controlled conditions.

Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

although again, beware the priority boost option is almost never a good idea… I’ve never seen it used sucessfully, but seen it used unsucessfully a number of times… It can cause the OS itself to be starved from CPU resources… Cheers
Twan

]]>