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.

Filter by
Sorted by
Tagged with
12
votes
1answer
2k views

Query Store Force Plan feature doesn't work

Query Store Force plan feature doesn't appear to be enforcing the plan. I'm aware of Query Store - Forced Doesn’t Always Mean Forced; however, my plan may not change insignificantly, but query ...
2
votes
0answers
590 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 ...
17
votes
1answer
8k views

SQL Server 2016 Bad Query Plan locks up DB once a week

Once a week, for the past 5 weeks, around the same time of day (early morning, may be based on user activity when people are starting to use it), SQL Server 2016 (AWS RDS, mirrored) starts timing out ...
11
votes
1answer
2k views

Does SQL Server Query Store capture parameter values?

The new Query Store introduced in SQL Server 2016 is great. It's a nice replacement for much of what I used to do with the older Profiler tool. However, I haven't found a way to capture parameter ...
3
votes
1answer
582 views

How to interpret Azure SQL QueryStore Query Performance Insight

The Azure SQL QueryStore is supposed to give you insight into what is causing high DTU usage, but I can not figure out what is going on. In some cases, I get good data out of it, and I can pinpoint to ...
1
vote
1answer
903 views

Delete from table with(snapshot)

I was trying to learn querystore. When going through few queries involved in query store one of the query is below DELETE TOP (1000000) FROM [sys].[memory_optimized_history_table_1179151246] WITH (...
1
vote
1answer
354 views

How can you view the Query Store settings for a database?

I see that you can use notion like the following to set the query store configuration: ALTER DATABASE <database name> SET QUERY_STORE (SIZE_BASED_CLEANUP_MODE = AUTO); But how can I ...
4
votes
1answer
2k views

How to list all forced query plans and cancel one

Using SSMS 2016 Query Store I forced a few weeks ago a specific query to use a specific plan. Now every now and then I have the error: Query processor could not produce a query plan because of the ...
7
votes
2answers
2k views

Indexes and Statistics on Temp tables

I've just upgraded our Data warehouse to SQL 2016. I'm seeing some really interesting graphs in the Query Store (I love this feature!). Below is the weirdest example i've seen. 22 plans for the same ...
5
votes
1answer
3k views

Problems caused by SQL Server 2016 Query Store

I have been testing SQL Server 2016 (Standard) on an Azure VM and have encountered a problem. In my SQL logs I am seeing SQLExceptions and eventid 1001 and this is happening every 15 minutes. 2016-...
4
votes
1answer
3k views

How to enable query store on the SSMS object browser with Sql Azure?

I am following this guide: Monitoring Performance By Using the Query Store I am using SSMS 2016 CTP3.2 and Sql Azure V12 I have enabled the query store on the database properties. I can use the ...

1
2