• Grant Fritchey (8/15/2012)


    You're experiencing I/O waits during I/O operations... The only way to speed that up is to get faster/more disks.

    Are you sure you're not thinking of PAGEIOLATCH_UP? I think PAGELATCH_UP is a memory latch (buffer, i.e. not I/O) caused when doing an update. At a guess there is potential for allocation contention issues when you see this wait. Can you provide the DDL for the partitioned table? How many rows are you inserting?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato