Performance upgrade op SQL VM
Hi,
I did setup a new VM for SQL. Software vendor installed SQL2017 on it and their application. Clients are complaining about performance and speed of the application.
Is there a way i can approve the performance of the virtual machine or with other words the performance of the application. by adding more VCPU ? more Memory ? other settings ??
Any help would be welcome.
This is the Host i use :
HP DL380 G10 - 2 processors XeonSilver 4110 - RAM 144Gb - SAS disks 10K
RAID5 -> Host
RAID6 -> VM’s
These are the VM settings for the (VM) SQL-server
1 Virtual CPU
32Gb RAM (not dynamic)
Disksize is 1Tb
Regards,
Jo