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: 255

Filed under:

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

Related posts about sql-server