Published January 26, 2022.
Purpose
To show the plan cache usage over time.
Sources
This feature queries the DMV sys.dm_exec_cached_plans which returns information about the objects and their size in the plan cache.
Reports
The report page Plan Cache Usage has a line and stacked column chart showing the size of object types over time as well as AdHoc %.
Model
The model for the report uses the fact [Plan cache usage] and the dimensions [Date] and [Time].
Configuration
There is no configuration for this feature.
Scheduling
The default schedule for the feature is every 5 minutes (300 seconds).
Retention
The default retention for the table dbo.fhsmPlanCacheUsage is 90 days.
