This blog is part of the blog series named SQL Server Monitoring.
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.
Report
The report has a line chart in the upper half showing the number of connections over time, and a table in the lower half showing the number of connections per database and with the possibility to drill down to program and host level.
Model
The model for the report uses the fact [Connections] and the dimensions [Date], [Time] and [Connection info].
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.
