Published January 26, 2022.
Purpose
To show the CPU utilization over time.
Sources
This feature queries the DMV’s sys.dm_os_ring_buffers and sys.dm_exec_query_stats which returns information about CPU utilization overall, per database but also about other (non SQL) processes.
Reports
The report page CPU has 2 line charts, one showing the CPU utilization by SQL and other processes, and the other showing the top 3 databases in terms of CPU usage based on the plan cache information.
Model
The model for the report uses the 2 facts [CPU per database] and [CPU utilization], and the dimensions [Database], [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 tables dbo.fhsmCPUPerDatabase and dbo.fhsmCPUUtilization is 30 days.
