What is the benifit of using Use Windows NT Fibers Option in SQL 2000 server???
Database
2
Posts
2
Posters
0
Views
1
Watching
-
What is it and benefits of it??? Thanks in Advance.
-
What is it and benefits of it??? Thanks in Advance.
It's designed to decrease context switches in multi CPU environment, thus giving a little bit better performance in certain, very specific situations. Normally there's no need to use it (or at least lots of optimizations should be done before this is considered). For more info: The Perils of Fiber Mode[^]
The need to optimize rises from a bad design.My articles[^]