Question : When I look at the Query Store reports for Top Resource Consuming Queries, there is one query that […]
Tag: query-store
Database corruption: QueryStore internal table
Question : This morning, the following email alert was received: DATE/TIME: 2/28/2018 9:26:42 AM DESCRIPTION: Attempt to fetch logical page […]
SQL Server Query Store – What is considered an ‘ad-hoc’ query?
Question : I’ve been doing a deep dive into the SQL Server Query Store and I often see references to […]
Does killed session appears in Query Store?
Question : Is there any option to see killed sessions in Query Store? I am asking, because we have an […]
Should I believe Query Store runtime stats?
Question : There is this weird behavior of Query Store runtime stats that I observe at many of my servers […]
Unbelievably slow and unusable Query Store
Question : I’m beginning with Query Store and it’s with problems 🙁 No report of Top Resource Consuming Queries is […]
Query Store internal queries being executed thousands of times per minute
Question : I have an SQL Server 2016 Standard production server with more 59 clients Databases. Microsoft SQL Server 2016 […]
How do I query for system views in a SQL Server database?
Question : I have some queries that run against Query Store, the view sys.query_store_wait_stats is not in SQL Server 2016, […]
Don’t RESEED tables on Query Store Clean
Question : We are using Query Store. And now we have solved one problem with it by cleaning the Query […]
Query Store Force Plan feature doesn’t work
Question : Query Store Force plan feature doesn’t appear to be enforcing the plan. I’m aware of Query Store – […]