Use Windows NT Fibers
-
In what circumstance would you set your Win2k server to 'Use Windows NT Fiber'?
-
quote:
In what circumstance would you set your Win2k server to 'Use Windows NT Fiber'?More than three processors, processor utilization at or near 100% for protracted periods, and context switches/second above 20,000 during those periods. Still would avoid in a production environment as some facilities won't work (e.g. OLE Automation) and you are more likely to encounter bugs in SQL Server.
It's helpful for TPC-C benchmarking.
--Jonathan
--Jonathan -
To piggy-back on Jonathan this topic has also been discussed here
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=14941
http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12303
HTH
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Thanks!
-
The links provided above in Frank's response no longer work, can someone post the new links?
-
my understanding is that it's aimed at 16 processor threads and above
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply