• OK. wanna check something first. Those values are for the sec/read, not the read/sec?

    If so, You have major IO problems! The memory doesn't look bad, the cache hit ratio is high and the lazy writes are low.

    A value of 29 seconds on average to do a read from disk is horrifying. The recomendation is 10-50 ms.

    An average write duration of 9.4 seconds is also far, far above what it should be. Recomended here is also 10-50 ms

    What's your drive config? How many physical drives do you have in the server? Where is tempDB, the database's data file, the database's log file?

    Do you have a RAID array or single drives? If RAID, what level?

    Is SQL the only thing on this server?

    The full scans/sec look a little higher than one would like. It indicates that some of your queries are doing table scans to find their data. You may need to evaluate indexes.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass