Which SQL Server component is in charge with checking cached execution plans for a given query?
1
vote
1
answer
115
views
I understand that whenever SQL server receives a query it looks in the cache plan for any matching execution plans for that query. However, most of the resources that I encountered don't specify which component is in charge of this lookup. This article suggests that it's the Buffer Manager, but I failed to find any evidence for this in Microsoft's Query processing architecture guide . On the other hand, the speaker in this presentation (around 42:43) seems to suggest that it's the Cmd Parser. So, which one is it?
Asked by Mehdi Charife
(131 rep)
May 12, 2023, 11:23 AM
Last activity: May 12, 2023, 07:31 PM
Last activity: May 12, 2023, 07:31 PM