Solved

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

Posted on 2012-04-05
4
601 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 55

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 55

Accepted Solution

by:
andyalder earned 400 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
today minus 2 years SQL server 2008 2 31
Can't create RAID on a HP Z220 CMT, preparation for VMWare. 6 81
TSQL DateADD update Question 4 32
RAID Configuration 18 20
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Having issues meeting security compliance criteria because of those pesky USB drives? Then I can help you! This article will explain how to disable USB Mass Storage devices in Windows Server 2008 R2.
This video teaches viewers how to encrypt an external drive that requires a password to read and edit the drive. All tasks are done in Disk Utility. Plug in the external drive you wish to encrypt: Make sure all previous data on the drive has been …
This tutorial will walk an individual through the process of installing the necessary services and then configuring a Windows Server 2012 system as an iSCSI target. To install the necessary roles, go to Server Manager, and select Add Roles and Featu…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now