Proxmox VE 9.1.1 – Windows Server / SQL Server issues

[tigro11]

Good morning,
We have recently resumed work with Proxmox VE 9.1.1. My client is experiencing slow execution of operations on Microsoft SQL Server 2019.
Proxmox behaves strangely, consuming 100% of memory, even though on Windows Server 2025 there is no significant memory usage observed.
Some time ago, I had already opened a ticket regarding the same SQL Server performance issue.
The VM is configured with virtio-win drivers version 0.1.271, as these are reported to be more stable.
Thansk

Valerio

 

[alexskysilk]

there is nothing unusual about a windows VM laying claim to all assigned memory. this is normal. as for your performance issues, please post the content of:
vmid.conf
/etc/pve/storage.cfg

 

[alexskysilk]

On reflection, storage.cfg doesnt tell us anything useful; instead, post the storage configuration- raid level, disk technology and count, and subrank block size (eg, if you have a striped mirror using 4k disks, subrank size will be 4k; if you have a 10 drive raid6, block size will be 32k, etc.)

Lastly, I suppose a definition of "slow" would be useful as well. do you have benchmarks to share?