Contents x
    Connections
    • 22 Jan 2024
    • 4 Minutes to read
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Contents

    Connections

    • Updated on 22 Jan 2024
    • 4 Minutes to read
    • Contributors
    • Print
    • Dark
      Light
    • PDF
    Article summary

    The Connections screens display information related to the user connections into each database grouped by the instance(s).

    Explore Connections:

    Dive into details and summaries with two dedicated screens: Overview and Details.

    Overview:

    • Get the gist: Quickly grasp key Security Account information in a concise format.

    • Customize your view: Use filters and a time range to focus on what matters most.

    • Consistent experience: Your settings carry over between screens for a seamless workflow.

    Details:

    • Deep dive: Drill down into individual accounts and their specific security status.

    • Fine-tune your analysis: Apply various filters and adjust the time range for in-depth insights.

    • Not all filters apply: Focus on relevant options specific to the Details screen.

    Need more guidance?

    • Master the filters: Refer to the "Drop-down Filters" documentation in the User Guide.

    • Set the right time frame: Learn about "Choosing a Time Range" in the User Guide.

      The filter options available for the 2 screens are defined below:

    • Environment - Tags defined for each instance in the Instance - List section, like Production, Development, Staging, or other options.

    • Instance - The name of the instance being monitored.

    • Host - The server name of the machine hosting a SQL instance or is monitored.

    • Database - The name of the database on the SQL Instance(s).

    • Login - The Account or Group created in the Security folder on the SQL Instance(s).

    • Program - The name of the application connecting to a SQL instance(s).

    • Weekday - Filters the display to the days selected (a day is midnight to midnight local browser time).

    • Time of Day - Allows the filtering by predefined 4-hour blocks of time.

    Expand the Overview or Details for more information.

    Overview

    Overview Screen

    Overview

    The Overview consists of 3 areas, the User Connections Activity chart, the Connections Summary table, and the Slicers.

    Connection Activity

    This chart visualizes the top 3 SQL instances by connections per second (CPS) over a specified time range. It employs a line graph format, with each instance represented by a distinct color. Users can interact with the chart to customize its appearance and access detailed information with the toggle switch in the upper right corner of each instance box.

    First, the recorded or aggregated connections per second are displayed when the mouse is hovered in the chart. The CPS displayed will correlate with the pop-up displayed on the chart for the plot point. The pop-up will honor the toggles and display all CPS values for the instances toggled on. The average CPS of the instance for the time range selected is, is displayed and does not change.

    Below the instance name, the connections per second are displayed when you hover over the chart, otherwise, two dashes are displayed representing no data available. The CPS, when displayed, will correlate with the pop-up shown on the chart for the plot point. The pop-up will honor the toggles and display all CPS values for the top 3 instances that are toggled on and display the aggregated time or plot point being used. The length of the time range selected determines the aggregation for the plot points. See the Charts documentation in the Navigation and Tools Available section of the User Guide.

    The Avg: number at the bottom displays the average connections per second for the selected time range and does not change.

    Connections Summary

    The connections summary consists of a table listing connection information with a default grouping by database per instance. The data displayed in the default table consists of the following columns:

    • Instance -

    The Group By box in the upper right corner of the table allows the data to be grouped and aggregated by the Instance, Host, or Database instead of the default. Once a grouping has been applied,

    Details

    Details Screen

    Was this article helpful?
    What's Next