Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2012-04-05
4
Medium Priority
?
661 Views
Last Modified: 2012-05-16
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.
0
Comment
Question by:sherryfitzgroup
  • 2
  • 2
4 Comments
 
LVL 56

Expert Comment

by:andyalder
ID: 37812410
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
 
LVL 2

Author Comment

by:sherryfitzgroup
ID: 37896630
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
 
LVL 56

Accepted Solution

by:
andyalder earned 1600 total points
ID: 37896831
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
 
LVL 2

Author Closing Comment

by:sherryfitzgroup
ID: 37974080
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Each year, investment in cloud platforms grows more than 20% (https://www.immun.io/hubfs/Immunio_2016/Content/Marketing/Cloud-Security-Report-2016.pdf?submissionGuid=a8d80a00-6fee-4b85-81db-a4e28f681762) as an increasing number of companies begin to…
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

927 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question