Kubernetes is indeed complex to setup and maintain. That's why except the odd containers we work with vm's on-premises.

The cloud can handle that complexity better behind the scenes.

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/

https://www.brentozar.com/archive/2012/03/how-decide-if-should-use-table-partitioning/

I'm quite hesitant to use partition because it requires maintance and good queries that support it. Maybe the odd partition swap.

As Brent usually mentions, what is the developer trying...

Recently I had the opportunity of 3 monitors and I liked it.

1 as main screen, 2 as internet browsing / compare, 3 as backgrond monitoring/email etc

The 504 gateway error is annoying. So far the posts went through

We don't have an official off hours call support duty. The occasional call may get fixed if the person feels up to it, otherwise it is postponed to working hours.

The square ones didn't complete

https://joeydantoni.com/2016/11/02/circles-and-squares-what-do-they-mean-in-the-query-store/

The library is open-source, you may find the information there https://github.com/codebude/QRCoder

For simple operations Standard Edition is fine. Differences can be found at https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2022?view=sql-server-ver16#choose-sql-server-features

Is the execution plan between 2008 and 2017 the same? Are they fully patched?

If it bugchecks I would considering contacting MS Support, since you are allready on the latest CU.

Happy bunny hopping / bell watching / ... . Easter is nearby

https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/performance/troubleshoot-application-slow-ssms-fast

David, are you referring to Digital Operational Resilience Act (DORA) or Dora the explorer?

*edit* Thanks for posting your solution natek11. I hope this helps the original poster

Thanks Frederico for the demo. I'll try it out