Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [query-store]

Introduced in SQL Server 2016, the Query Store feature collects execution plans and runtime performance metrics for analysis, troubleshooting, and testing purposes.

0
votes
1answer
32 views

How to search Query Store for queries with multiple plans?

There are a number of blog posts about why a single query with multiple plans is bad. But they mostly address when you find them, not how to find them. Query Store does not offer a report, that ...
7
votes
0answers
93 views

SQL Server 2016 & 2017 Force Plan failing with reason 8695

I'm trying to force a plan using query store but it keeps failing with reason 8695 according to data in SYS.QUERY_STORE_PLAN the last_force_failure_reason_desc is 'General_Failure'. Does anyone know ...
2
votes
0answers
46 views

Query store works in dev, but not production in Amazon RDS

I'm having an issue getting query store to collect and record data on our production workload, however, it works as expected on our non-production instances (development and staging). The only ...
2
votes
0answers
300 views

Query store is slow/unresponsive

When opening the query store for the first time on any give day, it will take a VERY long time to output data. I took a SQL script from this redgate blog article : Top 10 most expensive queries ...
2
votes
0answers
297 views

Query Store on Amazon RDS

I'm trying to use Query Store on SQL Server on Amazon RDS, and not having any luck. The query store works for a few hours after each failover, but then stops working. For example, our last manual ...
1
vote
0answers
49 views

Query Store- force plan not working as expected

Have similar issue as was ask in other question. In my case none of cases from microsoft docs seems to apply Can something else be the reason? Schema changes not happening, but after index ...
0
votes
0answers
16 views

Azure SQL Data Warehouse will always return zero (0)

I am studying Query Store, and while reading sys.query_store_runtime_stats I found these Average CPU time for the query plan within the aggregation interval (reported in microseconds). Note: ...