PAGEIOLATCH WAIT

Can someone help me understand the various causes of
pageio latch waits or point me in the direction of a good
resource on this subject (BOL info is not detailed
enough)? There are no other users on the system - and my
process is experiencing pageio latch waits. I'm guessing
that this issue is related to the disk subsystem, but
don't know for sure.superboy, you are right most times I have experienced pageiolatch issues have been disk sub-system driver issues
raid controller issue and usually anything related to H/W(disk) configuration/problems|||See http://SQLDev.Net/misc/waittypes.htm
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"superboy" <anonymous@.discussions.microsoft.com> wrote in message
news:d5b601c3ef20$380b9160$a601280a@.phx.gbl...
> Can someone help me understand the various causes of
> pageio latch waits or point me in the direction of a good
> resource on this subject (BOL info is not detailed
> enough)? There are no other users on the system - and my
> process is experiencing pageio latch waits. I'm guessing
> that this issue is related to the disk subsystem, but
> don't know for sure.

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
>