Influence of Virtual Storage Controller Type on Microsoft SQL Server 2019 Performance
Vedran Dakić · Annals of DAAAM for ... & proceedings of the ... International DAAAM Symposium · 2019
Influence of different virtual storage controller types on database performance when using VMware virtualization technology has long been debated, but not analyzed properly.In this paper, we're going to analyze the impact of different storage controller types on Microsoft SQL Server 2019 database performance on VMware's vSphere 6.0 hypervisor and try to reach a conclusion as to what's the correct way to design server and virtual machine infrastructure for optimum database performance when using a regular, on-disk database.We will also analyze potential problems that might arise from situations when we migrate from other virtual disk types to paravirtual.