Do-it-yourself scheduling in SQL Server
I could have given this post the title “Resolving scheduler contention for concurrent BULK INSERT” like the original article, but I thought this one would be more ‘catchy’.
Anyway, here’s another excellent article from Thomas Kejser, one of the hero’s from the SQLCat team with a good background of the internals of the SQLOS Scheduling mechanism.
You should definitely read it if you ever wondered something like ‘Why is there only one CPU core at work when I have 4 of them’.