High disk time on sql-server
Posted
by
Patrik
on Server Fault
See other posts from Server Fault
or by Patrik
Published on 2011-02-09T10:36:41Z
Indexed on
2011/02/09
15:27 UTC
Read the original article
Hit count: 287
sql-server
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.
© Server Fault or respective owner