SQL Server Performance

[SCOTTs]

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

[Jack Vamvas]

Re: SQL Server Performance

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.comwrote in message
news:1176210668 .184320.75600@l 77g2000hsb.goog legroups.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
>