• While that is true, #1 is partially true, though not infinite, #2 is true it is the expected behavior, I guess that parallism is not correct I did not really notice there was anything in there about what type, #4 is definitely not correct. The real reason we see this type of behavior which is what I was getting at is because of the attempt to keep all of the IO asynchronous. This is really an expected result from sp_who but the cause is IO. This can be aleviated in some cases but not all. I was looking more for a root of the why not something else I guess.

    Thanks for the reply.

    DEX
    😀
    The more you help the business, the more they will help you...well sometimes anyway.