stephen.sarre (12/9/2010)
Hi SteveAre you missing the data for the buffer cache hit ratio graph?
Steve
The Buffer cache hits are pegged at 100% (all that is required is found from cache).
I agree that the next things to look at are disk I/O and network contentions. I myself have seen hardware (disk) falling behind a couple of times, and predict I/O being the prime reason for performance bottlenecks in the future.
Thanks & Regards,
Nakul Vachhrajani.
http://nakulvachhrajani.com
Follow me on
Twitter: @sqltwins