Is it still a best practice to always have your Server Admin disable write caching on the logical disk in Windows when it will house SQL Server data/log files? In the physical world we were always recommended to do so, but what about for VM's with SAN storage?
We use VMware running Windows Server 2012 R2/SQL 2012 and have an EMC XtremeIO SAN. We are presenting the storage as RDM Physical to the VM and doing mount points to a single drive letter.
For Example:
D:\ - Mount Point
D:\Data - Data LUN
D:\Logs - Log LUN
Do I need to ask that the Windows level write caching on each presented disk be set to "Quick Removal" instead of "Better Performance"?
Owner & Principal SQL Server Consultant
Im Your DBA, Inc.
https://www.imyourdba.com/