Archives

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

Read full post . . . .

Go Que Newsroom Categories

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 36 bytes) in /home/content/36/8658336/html/goquecom/wp-includes/taxonomy.php on line 3363