How SQL decides how much procedure cache and how much buffer cache to use.
There are two main types of cache which SQL Server deals with, the buffer cache and the procedure cache. The procedure cache is where the execution plans for procedures and queries are storred. The buffer cache is where the actual data is cached so that SQL Server doesn’t have to go to disk to get often accessed data.