Hi pcat,
Welcome to the communities! The most popular high performance config for modern Windows Operating Systems on vSphere is to keep the boot drive on LSI (default), and configure the data drive as an additional disk attached to a VMware Paravirtual (pvSCSI) adapter. You should practice this config to understand the usage (i.e. this requires VMware Tools for the driver, new disks need to be online'd in Windows Disk Management, etc.). The pvSCSI adapter will decrease CPU consumption by ~30% and increase performance by 12%. Results may vary by workload, but these things are solid.
In general, one should never place the data drive on the same disk as the OS. This of course affects your ability to easily expand the volume live.
Also, there is a performance benefit to having multiple disks and multiple controllers from the Guest OS perspective. This allows the GOS to make more intelligent decisions in traffic copping it's own IO.
Multiple datastore VM configs have the potential to increase performance, but only if the underlying disk provides that value. In general, using multiple datastores is an old school approach and is not really done nowadays.
So my vote is for LSI boot and pvSCSI data. You can of course use LSI for everything (default) and there is nothing wrong with that. Just make sure you have a dedicated vmdk for data (i.e. not on the boot drive).
Once you get into high performance configs for SQL, you will definitely want TempDB, Logs and Data on pvSCSI adapters.
Example SQL:
SCSI 0:0 Boot (LSI)
SCSI 1:0 Data (pvSCSI)
SCSI 2:0 Logs (pvSCSI)
SCSI 3:0 TempDB (pvSCSI)
Note: It should be stated that fresh builds with pvSCSI are straight forward. However, converting an existing server to use pvSCSI requires some attention as the disks will need to be online'd in Windows Disk Management at first power on following the change. As such, before converting an existing LSI data drive to pvSCSI, one should disable services (i.e. SQL) that may try to write to that disk at startup. Once you online the disks, set the services back to auto and reboot.
Checklist - Converting an Exsiting VM Data Drive from LSI to pvSCSI
1. Set auto services to manual (for any in-scope apps that write to this disk)
2. Shutdown VM gracefully
3. Edit Settings and add/change SCSI controllers (i.e. LSI to pvSCSI)
4. Power on VM and online the disks from diskmgmt.msc in the GOS
5. Set services back to auto
6. Reboot
7. Confirm disks come online healthy
Note: I find the Get-VMDiskMap PowerCLI script very helpful for information gathering when performing tasks such as this. It shows the mapping of logical disk as we know it in Windows to the actual vmdk.
Feel free to ask if there are any questions.