I'm building a new VM that will be used as a SQL 2019 Standard server running Windows Server 2016 Standard. Very small environment with only 5 or fewer users connecting to the SQL server for use with an accounting application and small DBs. My single ESXI host is running 6.7 and all flash SSD storage on a Dell PowerEdge R740. RAID6 with 6 SSDs on a Perc H740p controller.
My question is regarding disk provisioning and best performance (Thick Provision Lazy Zeroed, Thick Provision Eager Zeroed, Thin Provision). I know in the past for best performance with SQL and Exchange setups, Thick Provision Eager Zeroed was considered best even though the space required. However, I am reading about the different disk provisioning setups when using all flash SSD storage and the differences appear to be somewhat the same now with the benefit of SSDs.
Any input is appreciated.
The following guide outlines all the performance impacts and the vmdk types concerning SQL DB deployment over ESXi: https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-bes...
The Exchange Server writes its data and also creating new items like email to the transaction log files before committing them to the information stores. So each of the mailbox database modification/paging will be written to a memory cache, and after a time duration, the Exchange server will commit the cache contents into the related information stores (of course operation like application-aware backups will do it too). Then we could say for better performance of the Exchange server, SSD disks that is used as a flash-based datastore for keeping the only dedicated VMDK for the storing of transaction logs will be a good best practice.