The Plan Cache table displays objects that are currently stored in the plan cache.
NOTE: To define global settings about data retrieval to the Plan Cache table, use the Plan Cache view in the Databases Administration dashboard. To access this view, click the In-context actions button at the upper right side of the screen and then select Agent settings. For details, see Setting Options for Displaying Data in the Plan Cache . |
The Cache Size by Object Type chart displays the amount of memory allocated to the plan cache over time, and breaks it down by object type. This display allows viewing trends of plan usage, which can be used for improving the queries used for retrieving the plans.
The Object Types chart shows various statistics for each type of plan cache object.
The number of objects of each type that are currently stored in the plan cache. | |
The rate at which each type of plan cache objects is being run (used). |
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center