I have already spoken about SQL Server monitoring, SQL I/O best practices, and general SQL performance best practices. In this post, I am going to talk about SQL Server Performance Tuning in a Virtual Environment.
Running SQL Server workloads within Hyper-V guest VM’s is a definitely a supported and a viable option for a production environment, with the assumption that limitations of a Guest VM have met the performance requirements of the customer workload.
I/O performance impact is minimal from VM when proper sizing and configuration is performed on the storage tier. Recommended to use Passthrough or fixed VHD.
Same throughput attainable, however, there is more CPU overhead with hyper-v enabled or when running SQL Server within a VM.
Total Read IO’s vs. Latency
I hope, this gives you a good idea about VM performance for running SQL Server Workloads.
Comments are closed.