Custom Area

The users can view various metrics of instances within the currently monitored group.

Through customization, the users can place all real-time charts, sessions, and lock monitoring tables supported by SysMaster in any desired location and size.

Clicking on a chart allows the users to navigate to the desired screen.

Custom Area Default Layout

Response Time

  • Displays the response time (Response Time) of SQL execution occurring across all instances within the group in a heatmap format.

  • The Y-axis represents response time, and the colors in the heatmap indicate the number of SQL statements corresponding to that response time.

  • Click the "More" menu to set the Y-axis time range and save it.

  • Starting Point: The minimum elapsed time value for SQL statements to be displayed on the chart.

  • Cell Height: The value that sets the Elapsed Time of each cell on the Y-axis of the chart.

  • Drag the heatmap area or click a cell to view the actual SQL execution details in a separate modal.

  • Clicking the Instance Name takes the users to another screen for the corresponding instance.

  • Clicking the SID takes the users to the Session Detail screen for the corresponding SID.

The column contents of the Long SQL List refer to the Chart Type.

TPS

  • Displays TPS (Transactions Per Second) for each instance.

Long Running Session Count

  • Provides the Elapsed Time of sessions being executed on each instance within the group, divided by time intervals.

  • The users can define interval values for four intervals based on Response Time.

  • Click the "See More" button to customize and save the time intervals.

Table

  • Displays the real-time Running Session / Active Session / Lock Tree status in a table format.

  • Clicking on the SID of each row allows the users to view the Session Detail and SQL Detail pages.

  • The users can expand the table by clicking the Maximize button. Before expansion, 10 items based on Elapsed Time are displayed, and after expansion, 50 items are displayed.

Note

  • Running Session: Sessions with a Status of RUNNING

  • Active Session: Sessions with a Status of ROLLING_BACK / TX_RECOVERING / SESS_CLEANUP / CLOSING


Customization

Right-click the Custom area to call the Add Chart menu, and the users can add a chart to the Custom area using Add Chart.

Existing charts are highlighted.

The users can select a chart from the Recommend section or choose from all real-time charts provided by the system master in the All section to display on the dashboard.

The users can delete a chart component by clicking the X button on each chart component, and adjust the position or size of the chart by dragging it.


Save changes

If the users have Admin privileges or higher within the group, or if the users have been granted Custom Privileges, the users can save changes to the Custom Area by clicking the Save button.

Clicking the Reset button will revert the changes.

Note

All modified content (Card View, Custom Area) will be shared with all users within the group.

Last updated