Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

share|improve this question
add comment

2 Answers 2

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

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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