I am running
Microsoft SQL Server 2019 (RTM-CU8) (KB4577194) - 15.0.4073.23 (X64)
Sep 23 2020 16:03:08
Copyright (C) 2019 Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervis
I have Query Store enabled but it is showing as "Read_Only" even though I have it set to Read_Write. When I try to view regressed queries, etc. I see an error:
"Query Store statement has map has reached memory limit". I have searched but found no articles on resolving this issue.
I increased the "Max Storage to 4gb, from 1 gb. I clicked on "Purge Query Data", I disabled and re-enabled the query store and I still get the same error.
Yes, all my data files have plenty of space in them. yes the files are still in the primary file group.
Data Flush Interval - 15 minutes
Statistics Collection Interval - 1 day
Max Plans Per Query - 200
Query Store Capture Mode - Auto
Size Based Cleanup Mode - Auto
Stale Query Threshold - 90
Wait Statistics Capture Mode - On
What do I do to resolve this?