Question : I recently updated our 2016 SQL Server to SP2 and the most recent CU (KB4458621) released in August […]
Tag: query-store
Monitor SQL Server stored procedure latency
Question : What is the best way to capture SQL Server stored procedure latency in SQL Server 2016? Plan is […]
Query Store “Overall Resource Consumption” details
Question : I want to know how much total CPU a database has consumed for a given date span, for […]
Trying to repair query store, but sp_query_store_consistency_check does not exist
Question : The query store on our SQL Server 2016 Standard (SP2 CU6) database has gone into ERROR state and […]
A Query in the Query Store shows high Logical Reads
Question : When I look at the Query Store reports for Top Resource Consuming Queries, there is one query that […]
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 […]