ubuntu server +firebird

[khasanov]

Hello
First of all, I apologize if there is a similar topic, but I searched and did not find anything that would help me or that I have not tried
I have an Ubuntu server with Firebirth uploaded, the databases are on SAS SSDs that are in RAID 1
On the same Proxmox I also have 2 VMs with Win 11 that work with an accounting server and use the databases from Ubuntu
In the office there are also 6 other physical computers with much weaker parameters than the VM and they work super fast with the accounting software compared to the VM
The 2 VMs in question, when working with this software, when reading and writing the databases, have a fairly large lag, which is sometimes minutes compared to the physical computers that also read and write to the same Ubuntu

What I have tried:
-Changing the CPU from kvm64 on the host
-i440 to q 35
-Upgrading the kernels
-Upgrading the cache in the Firebirth config file
-On the machines with Win 11, changing the bridge for use another lan card
and there is no change in the delay

 

[mariol]

Just to confirm: Physical Windows 11 computers and the two Windows 11 VMs access the same database running on the Ubuntu server using the same software. But only the two Windows 11 VMs are slow when reading/writing to the databases, correct?

 

[khasanov]

Yes,
Today i tried with win10 vm and situational is same

 

[mariol]

Yes,
Today i tried with win10 vm and situational is same

Thanks for your reply. Please give me some more information about your PVE node:

Info about your CPU: lscpu
Info about your storages: pvesm status → SAS SSDs that are in RAID 1 → is this ZFS?
And a config from one of your slow Windows VMs: qm config <vmid>

 

[khasanov]

CPU op-mode(s): 32-bit, 64-bit
Address sizes: 46 bits physical, 48 bits virtual
Byte Order: Little Endian
CPU(s): 72
On-line CPU(s) list: 0-71
Vendor ID: GenuineIntel
BIOS Vendor ID: Intel(R) Corporation
Model name: Intel(R) Xeon(R) CPU E5-2697 v4 @ 2.30GHz
BIOS Model name: Intel(R) Xeon(R) CPU E5-2697 v4 @ 2.30GHz CPU @ 2.3GHz
BIOS CPU family: 179
CPU family: 6
Model: 79
Thread(s) per core: 2
Core(s) per socket: 18
Socket(s): 2
Stepping: 1
BogoMIPS: 4594.30




RAID 1 not is ZFS
root@vsiko:~# lsblk -o NAME,SIZE,TYPE,MOUNTPOINT
NAME SIZE TYPE MOUNTPOINT
sda 745.2G disk
├─sda1 1007K part
├─sda2 1G part /boot/efi
└─sda3 744.2G part
sdq1 is ssd

this is VM machine with WIn11

 

[mariol]

The CPU(s) is probably powerful enough. Something seems to be missing from lsblk? For lsblk use the following command, this show you all important things about:

lsblk --ascii -M -o +HOTPLUG,ROTA,PHY-SEC,FSTYPE,MODEL,TRAN

this is VM machine with WIn11

Unfortunately, the screenshot only shows a part of your VM configuration. Please use the output of the command from my previous post. This will display the entire VM configuration. Based on the screenshot, I can already make the following suggestions for improvement:

• If you use your 2 CPU-Sockets (what is very good), also enable NUMA [0].
• Use VirtIO-GPU instead of Default GPU.
• You can also test other CPU types. For example, “host” or x86-64-v3...?
• For better performance we also recommend SCSI for the virtual disk bus [1].
• If all your virtual drives are SSDs/NVMEs, you can attach the flag [2].
• Virtio RNG can also further improve performance.
• Another test could be to assign a fixed amount of memory to the VM.

[0] https://pve.proxmox.com/pve-docs/pve-admin-guide.html#_numa
[1] https://pve.proxmox.com/wiki/Paravirtualized_Block_Drivers_for_Windows
[2] https://pve.proxmox.com/pve-docs/pve-admin-guide.html#qm_hard_disk_discard
[3] https://pve.proxmox.com/pve-docs/pve-admin-guide.html#qm_virtio_rng

 

[_gabriel]

physical computers with much weaker parameters

what do you mean ?
what physical cpu do they have ?

 

[khasanov]

what do you mean ?
what physical cpu do they have ?

various processors from pentium to i3, i5

 

[_gabriel]

exact model will be more useful.
Windows 10/2019 does not run smooth on this 10 years old Xeon CPU, even more when virtualized.
Many cores but run too slow for modern Windows.
In my exp. , was only OK with Windows 7/8/2008r2/2012r2

 

[khasanov]

exact model will be more useful.
Windows 10/2019 does not run smooth on this 10 years old Xeon CPU, even more when virtualized.
Many cores but run too slow for modern Windows.
In my exp. , was only OK with Windows 7/8/2008r2/2012r2

The problem is that Firebird 5.0 doesn't work on older Windows.
I can try with windows server 2016 rdp

 

[khasanov]

I've tried all these tests and even broke the machine a few times, now I'm going to try numa0