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:
http://groups.google.ch/group/microsoft.public.sqlserver.server/browse_thread/thread/b8e9970a1feb49f6/b8154738537bacaf?lnk=st&q=spid+Voutilainen&rnum=1&hl=en#b8154738537bacaf
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...
> Hi
> Have a look at the answer from Santeri Voutilainen [MSFT] on:
> http://groups.google.ch/group/microsoft.public.sqlserver.server/browse_thread/thread/b8e9970a1feb49f6/b8154738537bacaf?lnk=st&q=spid+Voutilainen&rnum=1&hl=en#b8154738537bacaf
> 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.
>>