From what I could find and read SQL Server uses memory to cache pages and to cache execution plans.
1. I know how I set the total memory used by the SQL Server.
Is it possible to set the split between the memory used to cache pages and the memory used to cache plans?
2. How does the "Cycling" / reuse of memory mechanism work?
When does the SQL server decides to drop old pages out in order to free memory for new pages? (does it simply works like Page that was not hit the longest time will be thrown first?)
If the mechanism does work, when is a correct time to use the "DBCC FREEPROCCACHE"?
Thanks in advance,