I am investigating a SQL server performance issue where the system
operates well at times and poorly at others. This SQL server is
connected to a SAN where I believe the issue lies. I have started some
testing using the SQLIOSimx86 utility from Microsoft with the
application stopped. My initial results show that there are quite a
few errors that indicate

"IO requests are outstanding for more than 15 sec."

I am next going to look @ the IO system as a whole (bios,driver
version)

Any thoughts? I can't seem to find any documentation regarding this
and whether this is acceptable.

Thanks,

Scott

What is you Buffer Cache Hit Ratio and Memory: Pages/sec counters
for a give period. If the Buffer Cache Hit ratio is 98 and up ,, yet your
Memory Pages/Sec is over 20 then this could indicate excessive services

--

Jack Vamvas
___________________________________
Advertise your IT vacancies for free at - http://www.ITjobfeed.com



"SCOTTs" <ScottPSheridan@gmail.com> wrote in message
news:1176210668.184320.75600@l77g2000hsb.googlegro ups.com...
>I am investigating a SQL server performance issue where the system
> operates well at times and poorly at others. This SQL server is
> connected to a SAN where I believe the issue lies. I have started some
> testing using the SQLIOSimx86 utility from Microsoft with the
> application stopped. My initial results show that there are quite a
> few errors that indicate
>
> "IO requests are outstanding for more than 15 sec."
>
> I am next going to look @ the IO system as a whole (bios,driver
> version)
>
> Any thoughts? I can't seem to find any documentation regarding this
> and whether this is acceptable.
>
> Thanks,
>
> Scott
>