Array Performance and Data Protection
cancel
Showing results for 
Search instead for 
Did you mean: 

Is iSCSI better for performance for SQL Server?

SOLVED
Go to solution
rottengeek35
Occasional Contributor

Is iSCSI better for performance for SQL Server?

This was asked a few years ago, and someone performed actual tests.  I'm wondering if Nimble has some benchmarks you can provide regarding the suggested in-guest iSCSI attached vs. a VMDK w/paravirtual SCSI driver? What about other scenarios?

If I'm not using Nimble for replication, is there a reason to use iSCSI?

Do you have performance numbers show me what to expect?  Multiple tests have been done on other SANs with varying setups and generally iSCSI doesn't win out.

My particular environment is VMware 5.5, SQL Server 2014 (mostly) and Nimble 3.7.

2 REPLIES
ndyer39
Honored Contributor
Solution

Re: Is iSCSI better for performance for SQL Server?

I haven't seen anything like this for a few years - mostly because performance between in-guest, VMFS and now VVols are pretty much even. The choice now becomes reliant on the way you wish to manage, snapshot and restore your datasets.

rottengeek35
Occasional Contributor

Re: Is iSCSI better for performance for SQL Server?

So my plan is to try replacing the iSCSI drives with VMDKs attached with paravirtual SCSI drivers on one of our high I/O test SQL Servers and see if there is any change.  Since these would be dedicated to SQL, would I still choose the SQL Performance plan?  I'm just replacing Data, Log and tempdb LUNS, moving corresponding files over.