I remember seeing a PDC presentation on the Windows Kernel regarding Threads vs Fibers and in it Mark R. mentioned that this caused SQL's Thread mode to run almost as fast as Fiber mode, but with added stability.

Does anyone have a link to this? Or similar?

I'll use this as a motivation to push people to 2008R2

link|improve this question

67% accept rate
feedback

2 Answers

up vote 1 down vote accepted

I don't know of anybody using Fiber mode for SQL after all these years and I cannot ever recall anyone ever telling me its a good idea. I know the following is rather old, but take a quick peek at this

http://msdn.microsoft.com/en-us/library/aa175385%28v=sql.80%29.aspx

However this article from Linchi gives a more positive spin

http://sqlblog.com/blogs/linchi_shea/archive/2009/05/04/performance-impact-thread-mode-vs-fiber-mode.aspx

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.