We are having major performance and latency issues with SQL Server 2019.
We are running on a "quiet" **VMware** instance connected to a **vSAN**.
According to MSFT documentation, best performance is obtained if the drives are formatted at 64k block size vs 4k.
Doing some research, VMware publishes that you should NOT use 64k but 4k block size if on a vSAN.
So which one is it and what is the science behind this?
Asked by Gary P.
(1 rep)
Feb 5, 2023, 06:45 PM
Last activity: Feb 6, 2023, 09:43 AM
Last activity: Feb 6, 2023, 09:43 AM