SQL plan cache properties
The option shows high-level information about the cache. This information includes cache size, number of plans, number of full opens and pseudo-opens that have occurred.
This information can be used to view overall database activity. If tracked over time, it provides trends to help you better understand the database utilization peaks and valleys throughout the day and week.
You can edit the Plan Cache Size Threshold property of your plan cache by right-clicking a property and selecting Edit Value. Under normal circumstances, this properties value is sufficient and altering is not necessary. If it is altered, take care to assess the performance consequences of the change. Note that any explicit designation of Plan Cache size is maintained across IPLs.
You might be able to edit some of the properties of your plan cache by right-clicking a property and selecting Edit Value.