pageiolatch_sh

Hi,
Our company has an average of 800 processes at any time and goes to 1000 at
peak time (found from sysprocess). Almost 25% of these processes have
waittype as pageiolatch_sh at any given point of time. Does that mean that
we have an IO bottleneck because of the query waiting for the data to be
retreived from the page.
Thanks.
NavinHello Navin,
Try http://support.microsoft.com/?id=271509 for an explanation of how to use
DBCC SQLPERF(WAITSTATS) instead to determine which wait type is most common.
Also look at "Opening Microsoft's Performance-Tuning Toolbox"
(http://www.winnetmag.com/Article/Ar...0925/40925.html) which contains
an exhaustive document
(http://www.winnetmag.com/Files/09/40925/Webtable_01.doc) describing wait
types, perfmon counters and their inter-connection.
HTH,
Arvind.
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
This posting is provided "AS IS" with no warranties, and confers no rights.
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-
"Navin Vishnu" <navinittiyamparampadh@.comcast.net> wrote in message
news:OktwHfedEHA.228@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Our company has an average of 800 processes at any time and goes to 1000
> at
> peak time (found from sysprocess). Almost 25% of these processes have
> waittype as pageiolatch_sh at any given point of time. Does that mean that
> we have an IO bottleneck because of the query waiting for the data to be
> retreived from the page.
> Thanks.
> Navin
>|||You may or may not have an IOP bottleneck. That wait is a wait on a disk to
memory buffer transfer. You might be having IO problems or memory pressure
or both. The problems might be from inadequate hardware or bad queries, for
example perhaps you're doing a table scan on a massive table becuase you're
missing an index. The articles referenced in the post by Arvind will be very
helpful...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Navin Vishnu" <navinittiyamparampadh@.comcast.net> wrote in message
news:OktwHfedEHA.228@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Our company has an average of 800 processes at any time and goes to 1000
at
> peak time (found from sysprocess). Almost 25% of these processes have
> waittype as pageiolatch_sh at any given point of time. Does that mean that
> we have an IO bottleneck because of the query waiting for the data to be
> retreived from the page.
> Thanks.
> Navin
>