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
| Component | Requirement |
|---|---|
| OS | Windows 10/11 or Windows Server 2016+ |
| Runtime | .NET 8.0 (included in self-contained package) |
| SQL Server | SQL Server 2016+ with Query Store enabled |
| Azure | Azure SQL Database, Azure SQL Managed Instance |
| Installation | None → single portable .exe, no admin rights required |