Documentation / Query Benchmark / Common Workflows

Common Workflows

Controlled experiments you can repeat and share.

Compare two query versions

  1. Open Version Compare; paste Query A (baseline) and Query B (candidate).
  2. Set iterations, think time, and cache mode (e.g., warm cache for steady-state).
  3. Enable functional validation if results must match.
  4. Run the benchmark; review duration, CPU, reads, waits, and plans.
  5. Export PDF/JSON/CSV for the PR or change record.

Cross-server / version upgrade test

  1. Connect Server A (current) and Server B (target build or SKU).
  2. Use the same SQL and parameters on both; align database compatibility settings intentionally.
  3. Run equal iterations; compare plans and waits — not just average duration.