[PVE-User] SQL server 2014 poor performances
f.cuseo at panservice.it
Mon Oct 28 15:47:18 CET 2019
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
More information about the pve-user