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.
Which SQL Server component is in charge with checking cached execution plans for a given query?
Mehdi Charife
- 131
- 1
- 12