[PVE-User] SQL server 2014 poor performances

[Fabrizio Cuseo]

Hello.
I have a customer with proxmox 5.X, 4 x SSD (WD blue) in raid-10 ZFS configuration, Poweredge R710 dual xeon and 144Gbyte RAM. Same problem with 4 x SAS 15k rpm drives.

A VM with Windows Server 2016, and SQL Server 2014.
The SQL performances are very poor if compared with a standard desktop pc with i5 and a single consumer grade SSD.

There is some tweak like "Trace Flag T8038" to apply to SQL 2014 and/or 2017 ? 

Thanks in advance, Fabrizio Cuseo