• stephen.sarre (12/9/2010)


    Hi Steve

    Are 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