Performance upgrade op SQL VM

Published January 23, 2019 | By

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,

Read full post . . . .

Posted in Hyper-V, Syndicate | Tagged Hyper-v, HyperV, Microsoft