Documentation / Query Benchmark / Tips & Troubleshooting

Tips & Troubleshooting — Query Benchmark

Requirements

  • Windows 10/11 or Windows Server 2016+
  • SQL Server 2016+ recommended (session wait stats / grant columns); earlier versions may omit some metrics
  • VIEW SERVER STATE (or equivalent) for DMVs; DBCC rights for warm/cold cache

Troubleshooting

  • App won’t start when copying only the EXE — Use the published single-file build that embeds native libraries (IncludeNativeLibrariesForSelfExtract).
  • Grant memory / DOP show 0 — Needs recent query stats visibility; very trivial plans may report 0 grant / DOP 0 or 1.
  • Warm/Cold cache fails — Missing sysadmin / ALTER SERVER STATE style rights; stay on Production safe.
  • Waits empty — Pre-2016 instance or missing permission on dm_exec_session_wait_stats.