Hi, I'm having performance issues with a MS SQL VM.
We have recently migrated from a legacy infrastructure to a brand new vSAN ready installation.
On our previous infra it took about 1 minute to complete a batch job, not it takes up to 10 minutes.
I have cheked for resource contention but VM is sitting alone on the ESXi host and has all resources reserved.
Also Host 2 40GBe interfaces and a 40GBe upstream switch
CAn you give some advice?
Warm regards
Hi nachogonzalez.
VMware has a complete guide to install MS SQL on VSAN. As this apps usually needs intensive IOs, i would suggest to take a look to the following things:
EDIT:
As for the OS:
Operating system settings:
SQL Server startup parameters:
Please keep me updated
Hi nachogonzalez.
VMware has a complete guide to install MS SQL on VSAN. As this apps usually needs intensive IOs, i would suggest to take a look to the following things:
EDIT:
As for the OS:
Operating system settings:
SQL Server startup parameters:
Please keep me updated
Thanks for the quick reply, let me reply to your marks.
As for the OS:Operating system settings:
SQL Server startup parameters: This is already done
Please keep me updated