topic Re: Paravirtual os LSI Logiac SAS controller for SQL server ? in ESXi Discussions

Paravirtual os LSI Logiac SAS controller for SQL server ?

ricky73 — Thu, 11 Jul 2019 05:50:37 GMT

In ESXi 6.0.0 U3 environment, OS guest is Win 2016 Datacenter Edition where runs SQL server 2014, what do you think about disk controller?

I set default LSI Logic SAS for SQL datafile disk but some told me It's necessary VMware Paravirtual controller where VM makes much I/O operations.

Re: Paravirtual os LSI Logiac SAS controller for SQL server ?

VysakhNair — Thu, 11 Jul 2019 05:54:40 GMT

ricky73

VMware recommends to use the VMware Paravirtualized SCSI (PVSCSI) Controller as the virtual SCSI Controller for data and log VMDKs.

"The PVSCSI Controller is the optimal SCSI controller for an I/O-intensive application on vSphere allowing not only a higher I/O rate but also lowering CPU consumption compared with the LSI Logic SAS. In addition, the PVSCSI adapters provide higher queue depth, increasing I/O bandwidth for the virtualized workload"

https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pd…

Re: Paravirtual os LSI Logiac SAS controller for SQL server ?

ricky73 — Thu, 11 Jul 2019 06:11:51 GMT

I read it on Vmware best practices for SQL server but can I use LSI Logic SAS for both OS and built-in Microsoft SQL databases?

I'll create the paravirtual controller for 2nd disk which will contain my new database.

What do you suggest?

Re: Paravirtual os LSI Logiac SAS controller for SQL server ?

bhards4 — Thu, 11 Jul 2019 06:44:59 GMT

Hi,

I suggest you to use VMware Paravirtual SCSI Controllers for the SQL db disks or any critical vms where you require high performace stroage I/O's

VMware Paravirtual SCSI controllers are high performance storage controllers that can result in greater throughput and lower CPU use. These controllers are best suited for high performance storage environments.

Regards,

Sachin Bhardwaj

---------------------------------------------------------------------------------------------------------

Was it helpful? Let us know by completing this short survey here.