SQL Server Monitoring – Connection Statistics

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.