Klaus Aschenbrenner3d ago
When you create a 230 GB database in SQL Server 2025, just to be able to demonstrate ZSTD backup compression more seriously... #sqlserver
Show threadKlaus Aschenbrenner

A simple comparison across the various backup compression algorithms in SQL Server 2025 (230 GB database backup on a 8 vCore VM, 16 GB RAM on Proxmox):

MS_XPRESS: 305 sec => 58 GB
ZSTD LOW: 203 sec => 50 GB
ZSTD MEDIUM: 310 sec => 44 GB
ZSTD HIGH: 936 sec => 41 GB

Nov 15 at 3:03pmWeb
Show threadKlaus Aschenbrenner3d ago
ZSTD with level MEDIUM gives you the same runtime as the traditional MS_XPRESS algorithm, but the backup is around 14 GB smaller. The level LOW is really fast (203 sec. vs. 305 sec., and the backups are still smaller (58 GB vs. 50 GB). #sqlserver #zstd #compression #performance