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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

andyalderSaggar maker's framemakerCommented:
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
andyalderSaggar maker's framemakerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.