zfs mirror with ssd bad iops

We have recently realized (as many others on this forum eventually realize) that our consumer grade SSDs just aren't cutting it when it comes to everyday IOPS performance: Terrible random write IOPS below 20 using the proxmox zfs benchmark tests System load spikes when running all our VMs...

We are trying to run MSSQL 2017 on window 2016 server. We do not have any RAID controller. Instead we have H330 mini HBA controller on our Dell R730xd. We have created ZFS mirror with 2 Crucial MX500 (2TB) drives with the following settings: ashift = 12 compression = off arcsize = 48 Gig The...