how to reduce PAGEIOLATCH_SH waits?

Hi,
I have heavy updates and the most frequent problem is the PAGEIOLATCH_SH
wait type.
The update is blocked by himself (using the sp_who1, I see the lock)
what can I do?
there is any hint or option to test?
which counter of performance I have to follow?
thanks.
Jerome.Hi
Have a look at the answer from Santeri Voutilainen [MSFT] on:
38537bacaf" target="_blank">http://groups.google.ch/group/micro... />
38537bacaf
In effect, your disk subsystem is not coping with what SQL server is
throwing at it.
Have a look at disk times, queue lengths and the like to identify the IO
problem.
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Jéjé" wrote:

> Hi,
> I have heavy updates and the most frequent problem is the PAGEIOLATCH_SH
> wait type.
> The update is blocked by himself (using the sp_who1, I see the lock)
> what can I do?
> there is any hint or option to test?
> which counter of performance I have to follow?
> thanks.
> Jerome.
>
>|||unfortunatly my HD subsystem is bad and I can't do anything.
I'm on a SAN and the results are really bad and we don't know why.
The guys in charge of the SAN work on it, but I don't see any improvement.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:D5AEA1D4-D2F8-47D5-83A0-FF224C74137B@.microsoft.com...[vbcol=seagreen]
> Hi
> Have a look at the answer from Santeri Voutilainen [MSFT] on:
> 4738537bacaf" target="_blank">http://groups.google.ch/group/micro...>
4738537bacaf
> In effect, your disk subsystem is not coping with what SQL server is
> throwing at it.
> Have a look at disk times, queue lengths and the like to identify the IO
> problem.
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
>
> "Jj" wrote:
>sql