I’m thrilled to be presenting a new session on SQL Server-on-VMware storage performance tuning as part one of four in the ActualTech Media Expert webinar series this Friday, March 4 2022, at 11am Central time.
Any change that you make in SQL Server — be it insert, update, or delete — must be hardened to disk before that transaction is considered complete. To ensure the change is made, SQL Server turns off all the OS-level caching and several other services. Now consider the common scenario of running SQL Server on Windows in a VMware virtual machine and writing to a SAN. If any component within these layers is not tuned properly, it will really hold you back. You may have the fastest SAN in the world, but if the VMware layer has been left to storage defaults, SQL Server will suffer. It’s like you’ve got a Porsche with square tires on it.