We've built a new SQL 2008 server and we are seeing high latency and low throughput to our Netapp 2050 on this server. During the restore of a 250GB database backup file from DAS to SAN, Windows Resource Monitor is showing disk latency >200ms and queue length near 10 on the Netapp LUNs. We are using an IBM x3850 server with IBM's re-branded Emulex 8Gb/s FC card, connected to a Cisco 9120 FC switch (which only supports 2Gbps, but we hope to upgrade those switches soon), which connects to the SAN. On a file copy within the OS, I'm seeing these throughput rates:
Single 30GB file, C/D/E are DAS, R/S/T are SAN.
E: > 😧 200-300MB/s
E: > R: 200-300MB/s
E: > S: 200-300MB/s
E: > T: 200-350MB/s
T: > S: <10MB/s
T: > R: 10-20MB/s
T: > E: 10-20MB/s
T: > 😧 10-20MB/s
The attached file contains sysstat and lun stats. I captured this data during the same db restore. I need help with the commands to troubleshoot the bottleneck and understanding how to resolve it.
Thanks!
Jim