469,097 Members | 1,304 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,097 developers. It's quick & easy.

SQL Server Performance

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

Apr 10 '07 #1
1 1816
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" <Sc************@gmail.comwrote in message
news:11*********************@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

Apr 11 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Varkey | last post: by
2 posts views Thread by Marc Melancon | last post: by
26 posts views Thread by David W. Fenton | last post: by
14 posts views Thread by diskoduro | last post: by
6 posts views Thread by Daniel Walzenbach | last post: by
4 posts views Thread by dorpnospam | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.