topic Re: Is iSCSI better for performance for SQL Server? in Array Performance and Data Protection https://community.hpe.com/t5/array-performance-and-data/is-iscsi-better-for-performance-for-sql-server/m-p/6982298#M189 <HTML><HEAD></HEAD><BODY><P>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&nbsp;reliant on the way you wish to manage, snapshot and restore your datasets.</P></BODY></HTML> Mon, 31 Jul 2017 20:50:38 GMT Nick_Dyer 2017-07-31T20:50:38Z Is iSCSI better for performance for SQL Server? https://community.hpe.com/t5/array-performance-and-data/is-iscsi-better-for-performance-for-sql-server/m-p/6982297#M188 <HTML><HEAD></HEAD><BODY><P>This was asked a few years ago, and someone performed actual tests. &nbsp;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?</P><P></P><P>If I'm not using Nimble for replication, is there a reason to use iSCSI?</P><P>Do you have performance numbers show me what to expect? &nbsp;Multiple tests have been done on other SANs with varying setups and generally iSCSI doesn't win out.</P><P></P><P>My particular environment is VMware 5.5, SQL Server 2014 (mostly) and Nimble 3.7.</P></BODY></HTML> Tue, 25 Jul 2017 21:05:13 GMT https://community.hpe.com/t5/array-performance-and-data/is-iscsi-better-for-performance-for-sql-server/m-p/6982297#M188 rottengeek35 2017-07-25T21:05:13Z Re: Is iSCSI better for performance for SQL Server? https://community.hpe.com/t5/array-performance-and-data/is-iscsi-better-for-performance-for-sql-server/m-p/6982298#M189 <HTML><HEAD></HEAD><BODY><P>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&nbsp;reliant on the way you wish to manage, snapshot and restore your datasets.</P></BODY></HTML> Mon, 31 Jul 2017 20:50:38 GMT https://community.hpe.com/t5/array-performance-and-data/is-iscsi-better-for-performance-for-sql-server/m-p/6982298#M189 Nick_Dyer 2017-07-31T20:50:38Z Re: Is iSCSI better for performance for SQL Server? https://community.hpe.com/t5/array-performance-and-data/is-iscsi-better-for-performance-for-sql-server/m-p/6982299#M190 <HTML><HEAD></HEAD><BODY><P>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.&nbsp; Since these would be dedicated to SQL, would I still choose the SQL Performance plan?&nbsp; I'm just replacing Data, Log and tempdb LUNS, moving corresponding files over.</P></BODY></HTML> Thu, 10 Aug 2017 15:59:39 GMT https://community.hpe.com/t5/array-performance-and-data/is-iscsi-better-for-performance-for-sql-server/m-p/6982299#M190 rottengeek35 2017-08-10T15:59:39Z