• smallmoney (4/7/2014)


    I'm new to this and just curious why can't it cut in line in the runnable queue.

    Because it's no more eligible to run than any other process. If it kept cutting in front, you could end up with thread starvation, where nothing except 56 gets to run or where 56 got way more time on the processor than anyone else.

    Say your supermarket queue had 1 person who needed a price check, one who asked for cigs to be fetched for him (here they have to be fetched by someone), one has a credit card which required authorisation and one forgot an item. They've all now got what they needed and are just waiting for the cashier to be free. Which is going to go first?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass