Querystore information missing, why?

  • Anyone experienced an interval in Querystore missing information? In the environment I'm in right now, there's a date-interval where there's no data collected (well, there seems to be one query stored only when I'm checking certain dates). I'm no expert in querystore or mssql administration but anyone knows what could've happened? Querystore settings looks okay to me as far as I can tell.

  • Querystore could have been full at that moment, then it switches to readonly mode skipping your query.

    Query store capture mode also influences what is captured. https://www.sqlozano.com/query-store-customising-your-capture-mode/

     

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply