dax_benchmark
Benchmark DAX query performance by optionally clearing cache, running timed executions, and reporting cold/warm timings with row counts to identify optimization opportunities.
Instructions
Benchmark a DAX query: optionally clear the engine cache (XMLA ClearCache on the session database), then run the query N times returning {coldMs, warmMs[], rowCount}. Timings are client wall-clock per run (execution + full row drain) - honest about what is measured; pair with start_dax_trace/stop_dax_trace for the FE/SE split and cache hits.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| runs | No | number of timed runs (default 2, max 20) | |
| query | Yes | the DAX query (bare table expressions get EVALUATE prefixed) | |
| sessionId | Yes | ||
| clearCache | No | issue ClearCache first so run 1 is a true cold run (default true) |