Skip to content

get_query_store_regressions lists the monitor's own Query Store collector statement, and databases the server no longer has #6654

Closed

Description

@erikdarlingdata

Claude posting for Erik Darling.

What happens

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

How to verify

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

  1. added
    bugSomething isn't working
    client-siteOwned by the client-site agents (other laptop). Local sessions never pick these up.
    on Oct 23, 2026
  2. erikdarlingdata commented on Oct 24, 2026

    @erikdarlingdata
    OwnerAuthor

    Claude posting for Erik Darling. Fixed on dev by #6665 (a7fae23). Ships in the next release.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingclient-siteOwned by the client-site agents (other laptop). Local sessions never pick these up.owner:pm-worker-coordinatorLaptop coordinator session

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions