Cooperative Fiber Mode Sample - Day 9

re: Cooperative Fiber Mode Sample - Day 9

SK — Mon, 20 Sep 2004 21:10:00 GMT

Excellent articles. I enjoyed your style as well.

If possible, could you also provide some information on if/how SQL Server 2005 has implemented managed fiber API?

SK

re: Cooperative Fiber Mode Sample - Day 9

Dino Viehland — Tue, 21 Sep 2004 03:41:00 GMT

SQL server has not implemented any such managed fiber API. In fact SQL tries to discourage access to users from performing any synchronization what so ever (and switching fibers will almost always involve some sort of synchronization!) A lot of SQL server installations don't run in fiber mode so even if it did expose such an API, it wouldn't always be in a mode where it could work.

Instead what SQL does is hosts the runtime and at points in the hosting APIs where synchronization occurs (blocking for critical sections, events, joining on threads, etc...) they re-schedule new fibers. This offers a cooperative mode of scheduling that is transparent to the user. SQL also gets notifications of when a thread is leaving the CLR's control (where cooperative scheduling won't be possible - for example during a P/Invoke) and when control returns back to the CLR. They can use those notifications to allow another thread to take over the execution of managed code at that point. And then they can stop running managed code on one of those threads when they get the notification that the CLR again has control.

Misc Musings

Niels SQL Server Blog — Sun, 26 Aug 2007 21:02:29 GMT

So I'm back again (at least for a little while). It seems that my blogging goes in cycles - a couple

Dino s Blog Cooperative Fiber Mode Sample Day 9 | storage bench

Dino s Blog Cooperative Fiber Mode Sample Day 9 | storage bench — Fri, 19 Jun 2009 10:45:42 GMT

PingBack from http://thestoragebench.info/story.php?id=5563