Question : Is there a way to isolate Query Store data to a separate volume? I have a thousand or […]
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 […]
Why is Query Store missing details?
Question : This is slightly complex to explain, but very easy to reproduce. Short version: For about 10%-30% queries (by […]
With SQL Server’s Query Store, how can cleanup avoid deleting “least expensive” queries?
Question : I’m only interested in resource consumption (QUERY_CAPTURE_MODE = AUTO), with a fairly short interval (e.g. INTERVAL_LENGTH_MINUTES = 5). […]
Does Query Store force plan persist following server restart?
Question : Would like to ask because cannot find this information. Does Query Store force plan persist following server restart? […]
What benefit is there from enabling Query Store on msdb?
Question : Of the SQL system database (master, model, msdb, tempdb) query store can only be used on msdb. I […]
Enable query store for all databases
Question : I want to start using Query Store with suggested setting by Erin Stellato. USE [master] GO ALTER DATABASE […]
How to configure Query Store for resource usage
Question : I want to know how many milliseconds of CPU utilization happens for a particular database per 5-minute period. […]
Query Store Settings
Question : I’m interested in the overall CPU utilization for a database in a time span. I see how to […]
Blocking caused by Query Store. Unable to clear or disable
Question : I recently updated our 2016 SQL Server to SP2 and the most recent CU (KB4458621) released in August […]