Much difference in performance of 10GbE over 1Gb for iSCSI on DB cluster?

I have a SQL Server 2008 cluster connected by iSCSI to my SAN. It connects via a 1Gb switch. The SAN I am using is an Equallogic PS4000, with a single RAID10 LUN. The disks are SAS 15k.  
Neither the switch nor the SAN have 10GbE capability, but I was considering an upgrade.
Would an upgrade to a 10GbE switch and SAN make much difference, or would I be constrained by Disk I/O regardless.
LVL 2
sherryfitzgroupAsked:
Who is Participating?
 
andyalderCommented:
If we assume the storage is set for 64K chunks and SQL is using 64k blocks all the time and that you would get 150 64K IOPS from a 15K disk then we can work it out. 150 * 64K = 9MB/s which is aprox 90 Mb/s, call it 100Mb/s per
mirrored pair of disks so 20 disks in RAID 10 = 1Gb/s, any more than that you would want 10Gb network. That's assuming the 1Gb is dedicated for server to storage and there's no storage to storage replication hitting the bandwidth.
0
 
andyalderCommented:
Can't tell unless you run perfmon and see if physical disk: bytes/sec or Network interface bytes are flatlining due to lack of bandwidth. You'll have to look at both read and write.
0
 
sherryfitzgroupAuthor Commented:
Thanks. Neither is flatlining as yet.
Theoretically though, if I upgraded my infrastructure to 10Gbs, what kind of disks would I need to match them in terms of I/O?
There would be no point in having the network infrastructure at this level if the performance was still hindered by the disks.
0
 
sherryfitzgroupAuthor Commented:
Thanks andy-good to know.
In the end I noticed that our 1Gb setup wasn't optimal. (multipathing was incorrectly configured)
This was fixed and resolved. Your calculations are useful though.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.