PAGEIO

Please Help.
A user of mine was deleting records in a table of about
40 million records it took almost an hour.
On Process/info activitiy I saw PAGEIOLATCH_EX. Any idea
what it means please.
Regards
Olutimi OloruntobaAssuming a SCSI RAID disk subsystem one hour for 40 million records is not
unexpected. The PAGEIOLATCH_EX is a fancy way of saying it is waiting for a
physical IO (disk read/write) to complete. Again, this is expected. If you
want to lower the impact of a large delete, break it up into smaller chunks.
--
Geoff N. Hiten
SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Olutimi" <olutimi@.hotmail.com> wrote in message
news:0b6001c36d6b$88a5c780$a601280a@.phx.gbl...
> Please Help.
> A user of mine was deleting records in a table of about
> 40 million records it took almost an hour.
> On Process/info activitiy I saw PAGEIOLATCH_EX. Any idea
> what it means please.
> Regards
>
> Olutimi Oloruntoba
>