Hi:
I ran into an issue when I looked to try to manually force a plan from SYS.DM_DB_Tuning_recommendations
The details columns lists (in Json) the execution script. >
Exec sp_query_store_force_plan @query_id = nnn, @plan_id = mmm
Upon running I get an error that Query with query ID (nnn) is not found in the query store. I checked the table SYS.Query_store_query and sure enough it is not there.
Why would the server get a tuning recommendation for a query that is not there? Would it have to do with the the amount of information the query store stores before it recycles its memory?
Thank you
----------------------------------------------------