• mberran (3/27/2014)


    GilaMonster (3/27/2014)


    What wait types are you seeing on your data modification queries?

    What do the disk latency counters look like (physical disk sec/read and physical disk sec/write)?

    I requested the information and here is what I was sent:

    C: (OS) – Disk sec/Read = 0.005

    C: (OS) – Disk sec/Write = 0.012

    D: (DBs) – Disk sec/Read = 0.019

    D: (DBs) – Disk sec/Write = 0.009

    E: (TransLogs) – Disk sec/Read = 0

    E: (TransLogs) – Disk sec/Write = 0.003

    Those look OK.

    And the wait types you're seeing?

    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