Skip to main content
1 of 3

Which SQL Server component is in charge with checking cached execution plans for a given query?

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.