I will try to get these within the next two days. I'm working the late
shift when the system is not being highly utilized. I will say that
the users are not complaining about performance. I'm just worried that
later on, this could be a problem as we add more users to the system.
Mike
"Ron" <support_at_dbainfopower.com> wrote in message news:<EKmdnVKgLMgnOabd4p2dnA_at_comcast.com>...
> Hello Bordenm,
>
> Can you post 15 minutes statspack report from the time of bad performance
> for review?
>
> If you can post one from the time of normal performance it would help as
> well.
>
> Regards,
>
> Ron
> DBA Infopower
> http://www.dbainfopower.com
> Standard disclaimer:
> http://www.dbainfopower.com/dbaip_advice_disclaimer.html
>
>
> <bordenm_at_methodisthealth.org> wrote in message
> news:db50b9a0.0402240410.492a1604_at_posting.google.com...
> > Ok, here is the scenario. We have an application, clinical, that the
> > db server is having pretty high I/O wait. It can be as high as 50 to
> > 60%, but it is not consistently like this. It is more consistently
> > around 30 to 40 during busy times. This is running on a p690 regatta
> > attached to a shark. The partition is set up with 7procs and 16gig of
> > ram. After the vendor has researched this a little, they have said the
> > the I/O wait will go down once we add more users to the application.
> > They are saying that the I/O wait is high because the processesors are
> > so fast that it processes the transactions faster than what it can
> > handle. Like I said, they say that the I/O wait will go down once we
> > make the runqueues go up by adding more users to the application. To
> > me, this doesn not sound correct.
> >
> > My question is, could this theory be correct? If it is correct,
> > doesn't that mean that we have an I/O bottle neck period and it should
> > be resolved? In my mind,since this application is on a SAN that we
> > should have almost no I/O wait and maybe more run queues than anything
> > period, no matter how many users are on the box.
> >
> > Thanks for you comments and opinions.
> >
> > Mike
Received on Tue Feb 24 2004 - 21:59:09 CST
