mccmx_at_hotmail.com wrote:
> However, the top 5 or 10 SQL's ordered by 'physical reads' are doing
> over 50% of the number of physical reads, but only accounting for 10%
> of I/O wait time.....
Then maybe there is a problem with the storage? Objects used by top SQLs are
on good drives but there is a very slow disk with some objects used by
other queries. That would explain why a huge part of I/O waits is caused by
queries that read (relatively) low number of blocks.
--
Michal Kuratczyk
Received on Thu Apr 20 2006 - 08:49:33 CDT
