meta data for this page
  •  

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
vm:proxmox:kvm:windows:mssql [2025/01/08 20:25] – niziakvm:proxmox:kvm:windows:mssql [2026/02/03 11:38] (current) – niziak
Line 2: Line 2:
  
 ===== move database files to optimized storage ===== ===== move database files to optimized storage =====
 +
 +Recommended NTFS cluster size for MSSQL is 64kB. So ZFS's ''volblocksize'' also should be 64kB.
  
 Move MSSQL guest data files to dedicated VM disk. Move MSSQL guest data files to dedicated VM disk.
Line 8: Line 10:
 <code bash> <code bash>
 zfs create nvmpool/data/vm-703-disk-3 -b 64k -V 16G zfs create nvmpool/data/vm-703-disk-3 -b 64k -V 16G
 +zfs set logbias=throughput nvmpool/data/vm-703-disk-3
 qm disk rescan qm disk rescan
 </code> </code>