Sample Header Ad - 728x90

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