A daily job's duration doubles while input volume is unchanged. What should the investigation compare?

Published
  1. Disable query instrumentation to reduce dashboard noise
  2. Execution plans, stage metrics and historical run characteristics
  3. Rebuild every upstream table before comparing runs
  4. Increase executor count without examining stage behavior

Comments — 0