Delete statement with waittype pageiolatch

i trying issue simple delete statement deletes 2 rows table of 444 rows , runs forever, wait type shows in activity monitor as pageiolatch_sh.

any suggestions?

thanks

satya

start collecting performance counters disks in perfmon. want collect following counters:

physical disk:

%disk time
average disk queue length

average disk read queue length

average disk write queue length

memory:

pages/sec

sql server memory manager:

memory grants pending

you have bottleneck somewhere in memory or io , counters should show is.

edit:

also have @ erlands sommarskogs aba_lockinfo:

SQL Server > SQL Server Database Engine

Lun