1 GbE iSCSI performance against virtualized Databases

[basem]

Hi all,

I have this scenario,

I am going to setup vSphere cluster, ESXi hosts will be connected to HP MSA 1040 via iSCSI connectivity (1 GbE).
there are Databases servers that will be migrated as virtual machines into this cluster.
I have read HP best practices and noticed this values of HDDs performance regarding to storage protocols

for 1 GbE:
Sequential Reads MB/s = 440
Sequential Writes MB/s = 420

while for 10 GbE, 8Gb FC and 6Gb SAS
Sequential Reads = 3100
Sequential Writes = 1650

My question is, regarding to Sequential Reads and Write MB/s, it is so low with "1GbE iSCSI" in comparison with 10 GbE or FC...

does this issue will forms bad impact on Databases performance (Oracle and MS SQL Server)??

thank you in advanced...

 

[dave_the_nerd]

Where are you getting those numbers? 1GbE should top out at 125 MB/sec (One GigaBit per second), 10GbE (10 GigaBit) should top out at 1250MB/sec, 8Gb FC at 1000MB/Sec, and 6Gb SAS at 750MB/sec. Those are the maximum transfer speeds of the bus.

It's a good idea to have a hard drive array behind the interface that is faster than the bus, though. But then again, it's a good idea to use SSDs for performance-critical database applications, budget permitting.

1GbE iSCSI is slower than 10GbE iSCSI because, well, 1 is 10% of 10.

Yes, slower connections can have an impact on database performance. But database performance is usually effected by the maximum IOPS of the disks - sequential transfers have a fairly modest performance impact overall. You can get good IOPS performance even over 1GbE iSCSI, if you have it set up properly and an adequate SAN backing it.