The Overview page summarizes connection activity across all monitored instances in scope for the selected date range. It's the starting point for spotting unusual connection volume before drilling into a specific instance on Details.
Navigate to Performance › Database Connections › Overview.
Use the Filters panel to change what is displayed. Filters can be combined, and each shows a count of available values in parentheses.
| Filter | Narrows to |
|---|---|
| Instance | One or more specific SQL Server instances. |
| Database | One or more specific databases. |
| Application Host | The server or workstation name the connection originated from. |
| Login | The security account or group used to connect. |
| Program | The application name reported by the client when it connected. |
| Weekday | One or more days of the week, midnight to midnight, browser local time. |
| Time of Day | One or more predefined time-of-day blocks. |
The Tag filter is available separately from the toolbar. See Tag Filter for details.
KPI Summary
Four cards summarize connection activity for the selected filters and date range.
| Card | Description |
|---|---|
| Peak Starting Window | The busiest one-hour window for concurrent connections within the selected date range, with the total connections recorded during that window below it. |
| Unique Logins | Count of distinct login accounts that connected during the selected date range. |
| Unique Programs | Count of distinct applications, identified by reported program name, that connected during the selected date range. |
| Unique Hosts | Count of distinct application hosts that connected during the selected date range. |
Each card shows percent change against the prior period of equal length.
Click Ask Advisor on the Peak Starting Window card to ask WISdom Advisor about what drove that window's connection volume.
Connection Activity
The Connection Activity card displays a heatmap of connection volume by day of week and hour of day across the selected date range. Each cell shows the connection count for that hour, shaded from cool colors for lower volume to warm colors for higher volume, so recurring peak periods, such as batch jobs, patch windows, or login storms, stand out at a glance.
Connection Details Table
This table summarizes connection activity by instance for the selected filters and date range.
| Column | Description |
|---|---|
| Instance | Name of the monitored SQL Server instance. |
| Connections Avg | Average concurrent connections to the instance over the selected date range. |
| Peak Activity | Time of day with the highest connection volume for that instance. |
| Unique Logins | Count of distinct login accounts that connected to the instance. |
| Unique Hosts | Count of distinct application hosts that connected to the instance. |
| Unique Programs | Count of distinct applications that connected to the instance. |
| Last Activity | Elapsed time since the most recent connection recorded for the instance. |
Click a column heading to sort the table. Use the column selector icon at the right end of the header row to show or hide columns; the columns listed above are all the columns available.
Clicking the Instance name opens the standard include, exclude, or copy popover, consistent throughout WISdom. Clicking the action icon (⋮) on a row opens two options:
| Option | Result |
|---|---|
| View Details | Opens Details filtered to that instance. |
| View Activity | Opens Workload Activity filtered to that instance. |
Rows per page defaults to 15, with the option to select 5, 10, 15, 25, 50, or 100.