This blog is part of the blog series named SQL Server Monitoring.
Purpose
To get a baseline of the server performance counter metrics.
Sources
This feature queries the DMV sys.dm_os_performance_counters which returns a row per performance counter that is in the master data table dbo.fhsmPerfmonCounters.
Report
The report has 2 line charts in the upper part where the left are showing batch request per second, and the right are showing compilations per second.
The lower part has a line chart showing information about page life expectancy, average as well as per NUMA node.
Model
The model for the report uses the fact [Performance statistics] and the dimensions [Date], [Time] and [Performance counter].
It is the same model that are used by the Always On traffic and Resource Governor report.
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.fhsmPerfmonStatistics is 60 days.
