|
|
Posted by Jack Vamvas on 04/11/07 08:27
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.googlegroups.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
>
Navigation:
[Reply to this message]
|