By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,750 Members | 1,367 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,750 IT Pros & Developers. It's quick & easy.

SQL Server Performance

P: n/a
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
Share this Question
Share on Google+
1 Reply


P: n/a
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.