High disk time on sql-server
- by Patrik
Hi
We have a dedicated sql-server 2008 r2 enterprise edition.
The setup is:
D: (data files) - stored on local ssd disks (not the same disks as log files) (raid 10)
E: (log files) - stored on local ssd disks (not the same disks as data files) (raid 1)
F: (transaction log backup) - stored remote on a SAN
Today we moved our log files to new disks (from F: to E:). From a shared volume ( F:(SAN)) to dedicated local disks (E:).
What then happend was that the "disk time", "avg. transfer time" and "avg disk write queue length" increased on the volume where we have the data files (D:) (not on the volume where the log files are located).
The data volume and log volume does not share disks, however they share the same controller card.
"Disk idle time" is low for all volumes.
One thought is ofcourse that the controller card might be overloaded.
But, we need more ideas on where the problem might be.
