Skip to main content

Multiple Instance Monitoring

Home > Select Project > Dashboard > Multiple Instance Monitoring

In Instance Monitoring, to monitor only one instance, Multiple Instance Monitoring allows you to check and compare metrics and active sessions of multiple instances on one screen. Graph charts make it easy to see how instances' metric values are trending and which instances have higher metric values.


If you select an agent to compare in Dashboard > Instance List, and then select Multi view, the Monitoring Multiple Instances menu appears.

Basic screen guide

Multi-instance Monitoring

  • Number 1 Instance

    It is a list of instances (databases) where the agent has been installed. The color of the instance matches the color of the graph chart placed on the screen. To exclude some instances of data from the graph chart, select the corresponding instances. If you select the instance again, the graph chart reflects the instance data.

  • number2 Status

    You can monitor the metrics related to the resources of your database server.

  • number3 Load Balance

    You can monitor whether the load is concentrated on one server by checking which instance has a high metric value.

  • Number 4 Graph chart section

    The horizontal axis of each widget is time, and the vertical axis is the metric number.

  • number5 Active Sessions | Lock Tree | Process Info

    You can view the active session, lock tree, and process information for a specific instance. Select Instance Name.

  • For more information about each metric, see the following.

  • For more information about the columns, see the following.

  • The process information can be viewed by additionally configuring the XOS agent. For more information, see the following.

Selecting a metric

You can change the metric of the graph chart widget placed on the screen to another one.

  1. Select Configuration icon on the upper right of the widget to change the metrics.

  2. If the Count selector window appears, select a desired metric.

    Count window

  3. Select Save.

The metric of the selected widget is changed.


For more information about each metric, see the following.

Layout setting

To set the layout on the metrics chart, on the upper right of the screen, select Layout configuration icon. Nine (3x3) metrics charts are set on the default layout, and you can change the number of charts on a page.

Layout setting

Using the active session section

Through Active sessions at the bottom of the screen, you can see the real-time active sessions. The following provides the guide for the button on the upper right of the table.

  • Stop icon: You can stop changing the data collected in real time. To restart it again, select Start icon.
  • Refresh icon: The list of tables is refreshed.

  • Column icon: The column header entries in the table can be displayed or hidden.

  • Filter icon: You can filter the list based on the column header entries in the table. After selecting the button, you can set the conditions in each header column such as Includes, Excludes, Equal, and Unequal.


    Adjust the column width if the text field for filter condition options is invisible.

  • Download icon: You can download the content of the table as a CSV file.

Stopping an active session

You can stop a session(s) that has been running for a long time.

  1. In the active sessions list, move your mouse cursor to the item.

  2. Select the Session kill icon that appears on the utmost right.

  3. If the Session kill window appears, enter the password.

  4. Select Apply.

The session is stopped.

  • Through the paramkey.txt file in the DBX agent installation path, you can find the password.

  • This feature is only available to the members with Edit role. For more information about member roles, see the following.

Zooming in the graph chart section

Active session

If the current screen is small and difficult to see the widget, you can check the graph chart widget in a wider screen. Select Down arrow icon in the Active sessions section at the bottom of the screen. The Active sessions section is collapsed and the graph chart widget section is enlarged.

To zoom out the graph chart widget, select Up arrow icon at the bottom of the Active sessions section.

See query details

To check the SQL query information of the current running session, select the query column in the Active sessions section. The SQL details window appears. You can check the SQL query statements and plan information.

SQL details

  • View SQL Statistics: You can go to the SQL statistics menu where you can check statistical information related to the SQL query statement.

  • Default Bind: You can bind the part set as a variable in the query sentence to the default value.

  • Reset Bind: You can release the bound default value and check the variable.

  • Formatting: You can improve readability by applying indentation and formatting to a SQL query statement.

  • Plan: To check plan information, enter DB Name, User Name, and Password, and then select Search icon.

Changing the table columns

You can display or hide the column entries in the table, and change their order.

  1. Select Column icon on the upper right of the table.

  2. When the Column Setting window appears, hide, add, or change the order of items to be displayed in the table columns.

    • Select a column, and then Left arrow icon, Right arrow icon, Add icon or Minus icon. Go to Visible or Invisible.
    • You can move the position by dragging the column while it is selected.
  3. After all settings are finished, select Save.


The setting is saved as a browser cookie value to maintain the state even after refreshing the page. If an error occurs between settings due to cookie deletion or other reasons, it is initialized.

Column information guide

tranindexTransaction index
userDatabase user name
hostHost name of CAS that performs transactions
pidBroker process ID
programClient program name
query_timeTotal execution time of active queries (unit: second)
tran_timeTotal execution time of transactions (unit: second)
transtatusTransaction status
lock_holderList of transactions that own a lock if transactions are waiting for the lock
sql_idID for SQL text
sql_textQuery statement being executed (up to 30 characters)
sql_paramLiteral value separated from query
sql_hashHash value of query (internal WhaTap control value)