SPLIT Range in partition table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » SPLIT Range in partition table

SPLIT Range in partition table

Rate Topic

Display Mode

Topic Options

Author

Message

balbirsinghsodhi

Posted Tuesday, February 02, 2010 11:22 AM

SSC-Addicted

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 11:08 AM
Points: 490, Visits: 1,350

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

Post #858149

murphy_rick

Posted Thursday, February 07, 2013 8:03 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 06, 2013 1:39 PM
Points: 1, Visits: 35

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.

Post #1417092

« Prev Topic | Next Topic »

Permissions