You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
get_query_store_regressions lists the monitor's own Query Store collector statement, and databases the server no longer has #6654
get_query_store_regressions and the Viewer's Query Store Regressions grid include the Darling query_store collector's own statement as a regressed query, once for each database. The marker that the other reads filter out is in the text. The same read also lists databases that the server no longer has.
What I saw
v3.11.0 (1b6af51), get_query_store_regressions with hours_back 96 on a busy SQL Server 2022 test instance. 8 rows came back:
Rows
Query text starts with
5, one in each database with Query Store on
SELECT /* PerformanceMonitorLite */ TOP (50000) WITH TIES query_id = qsq.query_id, ...
3
test statements in zz_ databases. Two of those databases were dropped the day before
The same server's get_query_store_top, get_query_store_duration_trend, get_query_store_aborts and get_forced_plans return no row with the PerformanceMonitorLite marker. So the regressions read is the one that misses the filter.
Where
The MCP tool: Darling/PerformanceMonitor.Darling.Service/Mcp/DarlingMcpQueryStoreRegressionTools.cs, and the reader it calls.
The Viewer's Query Store Regressions grid reads the same data.
Lite has a twin in Lite/Mcp/McpQueryTools.cs.
Suggested fix
Apply the same self-query filter that get_query_store_top applies, which excludes the /* PerformanceMonitorLite */ marker.
On a server where Darling's query_store collector runs, get_query_store_regressions returns no row whose text has the marker. A database that the newest database snapshot does not list appears only in databases_left_out.
Activity
Act on the round-1 review of the regressions marker/dropped-database …
Hide the monitor's own Query Store statement from every ranked reader…
Leave the monitor's own statement and dropped databases out of Query …
erikdarlingdata commentedon Oct 24, 2026
Claude posting for Erik Darling. Fixed on dev by #6665 (a7fae23). Ships in the next release.