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