VM win2012R2 with SQL SERVER

[Leonardo Ramirez]

Hi, A few days ago I change my VMWARE by PROXMOX, en convert my VM to KVS, so. Before that my system on th VM it was working very fast with out any issue. Now after the conversion my VM in proxmox are very slow, and the resources and harware are the same.

Could you tell me if I have to do any special settings in proxmox?, Aplication in my VM are: IIS, and SQL SERVER.

SERVER


VM1


VM2

 

[wolfgang]

Hi,

is there a reason why you use NUMA on a UMA Host?
Are you remove all VMWare drives in the VM?
Are all virtio dirvers installed?
If yes which version do you have installed and from where did you download these drivers?

 

[Leonardo Ramirez]

Hello,

is there a reason why you use NUMA on a UMA Host? I use NUMA because hotplug Memory requiered.
Are you remove all VMWare drives in the VM? And I removed all VMWare drivers
Are all virtio dirvers installed? Yes, they are.
If yes which version do you have installed and from where did you download these drivers?
Virito drivers, I used version 171, and I downloaded from https://fedorapeople.org/groups/virt/virtio-win/direct-downloads/archive-virtio/

Thanks,

 

[wolfgang]

This is is all OK.
Can you try to disable NUMA for a test and look if the performance is better?
The point at memory hotplug is that only 1GB is available at the boot the rest will recognize by the OS later.
Maybe Window SQL server detect only this 1GB.

 

[Leonardo Ramirez]

Hi, I did it, but I still have the same issue. Take a look at the images:





Summay said my CPU is almost 12%, but inside the VM said 97%. Memory said the same in both sides.

And TOP command on the PV:




VM

 

[guletz]

Hi,

As Proxmox also support Vmware disk format/vmdk, I would try to use as vDisk the vmdk format. Also I do not see what kind of cpu model do you use for your VMs (default=kvm or the host cpu model =better)

Bafta / Good luck !

 

[Leonardo Ramirez]

Hi, the CPU type is KVM64.


And, my format disk is RAW.

 

[guletz]

Hi Leonardo,

Try to change the cpu model from kvm to host cpu !

 

[Dominic]

Are you sure that you have comparable storage configurations (e.g. cache settings, storage technology) in ESXi and Proxmox VE?

 

[Leonardo Ramirez]

Well, I guess so. Because it's tha same server and the same number of VM. I only took the 2 VM in ESXI and converted to RAW (VMDK -> RAW). En formated the server with PRoxmox.

After that, both VM are very slow and take too much time to do their task.

 

[Dominic]

Having the same server does not imply that your virtual hard disks have the same cache settings.

You can verify that the guest agent works with

qm agent <vmid> ping

There are some performance tweaks in the wiki that might be helpful, too.