Skip to content

v1.1.0

Choose a tag to compare

View all tags
@ronaldgithub ronaldgithub released this 15 Sep 10:53
· 5 commits to main since this release
v1.1.0
95320bb

SQL Server 2025 Backup/Restore Benchmark — a Windows desktop tool for benchmarking SQL Server 2025's backup compression algorithms (MS_XPRESS, QAT_DEFLATE, ZSTD) across size, throughput, restore speed, and CPU cost.

Install

  1. Download SqlBackupBenchmark-v1.1.0-win-x64.zip below.
  2. Unzip and run SqlBackupBenchmark.exe.

No .NET install required — it's a self-contained, single-file build for Windows x64. On first launch, use the connection button in the header to point it at your SQL Server instance (defaults to localhost with Windows Authentication).

Requirements

  • Windows
  • A SQL Server 2025 instance you can back up and restore against
  • Intel QAT hardware, only if you want to benchmark the QAT_DEFLATE scenarios (skipped automatically otherwise)

Highlights

  • Backup tab — 11 fixed scenarios (NO_COMPRESSION, DEFAULT, MS_XPRESS/QAT_DEFLATE/ZSTD × LOW/MEDIUM/HIGH), run serially or in parallel, with duration, size, MB/sec, and space-saved ratio per scenario. Backups run WITH COPY_ONLY so they never disturb a database's real backup chain.
  • Restore tab — benchmark restore speed for the .bak files the Backup tab produced, each into its own scratch database.
  • Analyse — a table-level compression readiness report (size, storage compression, and column types that help or hurt compression) for the selected database.
  • Connection dialog — point the app at any SQL Server instance, Windows or SQL Login auth, with a Test Connection check.
  • Info dialog — a built-in reference on how each algorithm works and how column data types affect what backup compression can save.
  • CPU-aware: QAT_DEFLATE scenarios are automatically disabled on non-Intel CPUs instead of failing at runtime.

See README.md for details.

Assets 3
Loading