Solved

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

Posted on 2012-04-05
4
605 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
mpeg to mp4 free tool 8 78
Challenging SQL Update 5 42
SQL Server 2012 r2 - calculations/operation on many Temp Tables 6 21
MS SQL Delete Query 9 33
Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
When we purchase storage, we typically are advertised storage of 500GB, 1TB, 2TB and so on. However, when you actually install it into your computer, your 500GB HDD will actually show up as 465GB. Why? It has to do with the way people and computers…
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…
This Micro Tutorial will teach you how to reformat your flash drive. Sometimes your flash drive may have issues carrying files so this will completely restore it to manufacturing settings. Make sure to backup all files before reformatting. This w…

809 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