SPLIT Range in partition table

• balbirsinghsodhi

  SSCrazy Eights

  Points: 9210

  More actions

  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

• murphy_rick

  Grasshopper

  Points: 15

  More actions

  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.