Documentation / Query Benchmark / Overview

DBLense Query Benchmark — User Guide

Measure and compare SQL query performance with controlled iterations, concurrency, cache modes, wait stats, execution plans, and tuning tips — on one server or across two.

Overview

Query Benchmark proves whether a SQL change is faster, slower, or equivalent before you ship it. It runs your SQL under controlled conditions and reports duration, CPU, logical/physical reads, degree of parallelism (DOP), query memory grants, TempDB usage, session wait stats, and optional plan comparison.

  • Single Query — Benchmark one statement and analyze its metrics and plan.
  • Compare Queries — Run Query A and Query B (different SQL, databases, and/or servers) and see side-by-side results.

Naming uses Query A and Query B (neutral labels) so the same UI works for version compare on one server and cross-server tests.

Modes

  • Single Query Test — One connection, one SQL text, measured iterations.
  • Compare Queries — Two SQL texts (Query A / Query B). Optionally same server, different databases, or two servers. Optional parallel A/B run when concurrency is 1.

Test kinds: Performance (serial or light concurrency), Load, Concurrency, and Stress (stepped user ramp).