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