Published January 26, 2022.
Purpose
To show the number of connections over time.
Sources
This feature queries the DMV sys.dm_exec_sessions which returns information for all active connections.
Reports
The report page Connections has a line chart showing the number of connections and whether they are system sessions or not.
Model
The model for the report uses the fact [Connections] 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 table dbo.fhsmConnections is 30 days.