Post reply

SPLIT Range in partition table

  • February 2, 2010 at 11:22 am

    #218812

    Whenever I use following function, I get one process blocked by other process. Any idea why is like that.

    ALTER PARTITION FUNCTION

    PFTRNAFunction()

    SPLIT RANGE (10402)

    Processes

    SPID Status Command Blocked_By

    61 Running UNKNOWN TOKEN .

    62 Background SELECT 61

  • February 7, 2013 at 8:03 am

    #1585444

    I am having the same issue as well. The partition that I am splitting has 4 million rows in it and I noticed that my data drive is being hammered with writes. On the first test box that I tried this on I started getting the UNKNOWN TOKEN and PAGEIOLATCH_EX waits. This lead me to believe there may be a disk subsystem issue on the first box, so I restored the database on a different box and tried it and I’m getting UNKNOWN TOKEN and SOS_SCHEDULER_YIELD waits and finely turned into PAGEIOLATCH_EX waits.

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

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