Tips & Troubleshooting — QueryStore Analyzer

FAQ

No databases appear after connect

Query Store must be enabled on the databases you care about. On Azure SQL it is typically on; on-prem run ALTER DATABASE [YourDb] SET QUERY_STORE = ON; (and confirm it is not in READ_ONLY due to max size).

Anomaly Detector or Execution Plan unavailable

Those features require an Enterprise license (or active trial). The license badge in the header shows Trial vs Licensed.

Plan Summary looks empty

Pick a query hash with recent executions in the selected time range, click Go, and wait for Query Store data to load. Very new queries may need a few intervals to appear.

System Requirements

ComponentRequirement
OSWindows 10/11 or Windows Server 2016+
Runtime.NET 8.0 (included in self-contained package)
SQL ServerSQL Server 2016+ with Query Store enabled
AzureAzure SQL Database, Azure SQL Managed Instance
InstallationNone → single portable .exe, no admin rights required