Details - Database Connections
The Database Connections Details page shows information about who is connecting to one instance. The graph quickly shows you the busiest and slowest days and times on the instance, allowing you to spot trends and patterns. You can then drive into each login by its originating host.
Selecting an instance
Section titled “Selecting an instance”The Details page requires an instance. You can:
- Select an instance in the Filters drop-down.
- Select a row on the Overview, or select View Details from its row-level action icon, to jump to Details with that instance already filtered.
Summary cards
Section titled “Summary cards”Four summary cards at the top of the page summarize the selected instance and time range.
| Card | Description |
|---|---|
| Connections | The number of connections to the instance, with the change from the prior period |
| Unique Logins | The number of distinct logins that connected, with the change from the prior period |
| Unique Programs | The number of distinct programs that connected, with the change from the prior period |
| Unique Hosts | The number of distinct hosts that connected, with the change from the prior period |
Connection Volume Over Time
Section titled “Connection Volume Over Time”The Connection Volume Over Time graph is a line graph of the number of connections for each aggregation period across the time range you selected. The time range is shown next to the chart title.
- The View Performance Metrics button on the chart card opens the Performance Metrics page under Health, with the counters for the selected instance displayed: Transactions/sec _Total, User Connections, and Batch Requests/sec.
- The default time range is 7 days, aggregated by 1 hour.
- Click and drag on the graph to zoom into the range you select.
- The aggregation can be changed depending on the size of the time range. You can go all the way down to 1 minute when the time range is 3 hours or less.
Connection Details table
Section titled “Connection Details table”The Connection Details table lists each combination of database, application host, login, program, and client interface that connected to the instance.
Columns
Section titled “Columns”All columns are displayed by default.
| Column | Default | Description |
|---|---|---|
| Instance | Yes | The name of the instance |
| Database | Yes | The database the connection used |
| Application Host | Yes | The host the connection came from |
| Login | Yes | The login that made the connection |
| Program | Yes | The program that made the connection |
| Client Interface | Yes | The client interface used for the connection |
| Connections Avg | Yes | The average number of connections |
| Last Login Time | Yes | The date and time of the last login |
To choose which columns are displayed, select the column chooser icon in the upper-right corner of the table and toggle columns on or off. The column chooser lists these eight columns. Your selections are kept in your browser cache and persist until the cache is flushed.
Header row actions
Section titled “Header row actions”The action icon (three vertical dots) in the table’s header row offers a full-screen view and an export option. Export creates an Excel file with all available columns, regardless of which columns are displayed. It does not ignore filters: only the data that matches the filters currently applied is exported.
Row actions
Section titled “Row actions”Select the row-level action icon (three vertical dots at the end of a row) for more options:
- View Details - Open the Connection Details flyout for that row.
- View Security Details - Open the Server Logins screen in the Security module, filtered by the instance and the login of the row.
- View Activity - Selecting View Activity jumps to the Workload Activity screen, with filters applied for the instance, database, application host, and login of the row.
Connection Details flyout
Section titled “Connection Details flyout”The Connection Details flyout shows one row in detail. Its header shows the instance, application host, and database as a path. Four summary cards appear above both tabs.
| Card | Description |
|---|---|
| Peak Period | The hour with the most connection activity, based on the selected time range |
| Peak Connections | The highest number of connections, based on the selected time range |
| First Activity | The first time WISdom picked up the login making a connection. This can be before the start of your selected date range. |
| Last Activity | How long ago the last connection activity occurred |
Two tabs follow: Session Properties and Connection Statistics.
Session Properties
Section titled “Session Properties”| Field | Description |
|---|---|
| Application Host | The host the connection came from |
| Database | The database the connection used |
| Login Name | The login that made the connection |
| Client Interface | The client interface used for the connection |
| Program Name | The program that made the connection |
Connection Statistics
Section titled “Connection Statistics”| Field | Description |
|---|---|
| Average Connections | The average number of connections |
| Peak Connections | The highest number of connections, based on the selected time range |
| First Activity | The first time WISdom picked up the login making a connection. This can be before the start of your selected date range, even more than a year earlier. |
| Last Activity | How long ago the last connection activity occurred |
