This blog is part of the blog series named SQL Server Monitoring.
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.
Report
The report has in the upper half 2 line charts, where the left line chart are showing SQL CPU % over time, and the right line chart are showing Other CPU % over time.
In the lower half to the left there are a line chart showing the number of CPU minutes over time, where the table in the right side shows CPU minutes per database 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 [Date], [Time] and [Database].
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.
