Published January 26, 2022.
To show the plan cache usage over time.
This feature queries the DMV sys.dm_exec_cached_plans which returns information about the objects and their size in the plan cache.
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 %.
The model for the report uses the fact [Plan cache usage] and the dimensions [Date] and [Time].
There is no configuration for this feature.
The default schedule for the feature is every 5 minutes (300 seconds).
The default retention for the table dbo.fhsmPlanCacheUsage is 90 days.