We have a server that was setup on Windows Server 2012. It is a MS SQL server that has 6 hard drives on SCSI Controller 0. The SCSI controller is set to LSI Logic SAS.
My question is:
Is there a benefit to splitting disks onto more than one SCSI controller? If I edit the VM and add a new controller and set it to VMWare Paravirtual, will Windows recognize the disks as before? VMWare tools is installed and up to date. VM version is 14.
Each scsi controller has it own queue which could be helpful with a high I/O VM. See the following link for more details: https://www.starwindsoftware.com/blog/storage-controllers-in-vmware-vsphere
Also regarding the paravirual controller, add it to the VM first as an second controller. This way Windows can load the drivers once done, you can change the controller hosting the boot drive. This way the VM will have the drivers loaded and boot up properly.
I attach link with the information, but within the previous recommendations the most important thing is to ensure that the operating system of the VM supports VM Paravirtual VM and VMware Tools is updated or installed on the VM.
As in all work that involves data it is advisable to make a full backup of the VM.
Additionally for windows systems from 2012 onwards it is recommended to use vmnext3 as NIC.