As far as I know, SQL Server automatically manages the size for the components of buffer pool. I wonder if it is possible to set pre-defined size for both plan cache and data cache?
Add a comment
|
1 Answer
No.
You can set Minimum & Maximum server memory to control the range of total memory utilization by the Instance, but there is not fine grained control for the constituent parts that make up "server memory"
-
Yes. The SQL Server design philosophy is strongly biased against exposing manual configuration settings. Here the system uses a Clock Algorithm to automatically manage the sizes of all the internal caches. See eg learn.microsoft.com/en-us/archive/blogs/slavao/… Jan 12, 2020 at 18:46