Post reply

block on tempdb?

  • June 4, 2011 at 8:15 pm

    #239362

    i just saw a block on tempdb? I am not sure how could that happen, because i thought objects created in tempdb are only within the scope of the program ?

  • June 7, 2011 at 2:35 pm

    #1335329

    There are tons of system I/O happening in tempdb.

    Tempdb is a place for instead of triggers, hash joins, sorts, version stores for snapshot isolation, cursors, indexing, (MARS), service broker ...etc.

    Alex S

  • June 7, 2011 at 4:59 pm

    #1335399

    Might also be a global temp table.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply