Analyzing the database
Home > Select Project > Analysis
It describes the database performance metrics that can be analyzed using the real-time monitoring.
Count trend
Home > Select Project > Analysis > Counts Trend
In Count Trend, you can check the following data.
-
Database running trend during the day
-
Key metrics for a specific time zone
-
Active Sessions
Select the Active Sessions tab at the bottom of the screen. Check information (including queries) of active sessions. For sessions running more than 10 seconds, they are displayed in yellow. For sessions running more than 20 seconds, they are displayed in red. You can see the query plans together.
-
Lock Tree
Select the Lock Tree tab at the bottom of the screen. You can see the lock information. The structure of holders and waiters is expressed in a tree form. A session lasting for more than 10 seconds is represented in yellow and a session lasting for more than 20 seconds is represented in red.
-
Process Info
Select the Process Info tab at the bottom of the screen. If you have installed the XOS agent, you can see the process information of the database server.
Comparison between count trends
Home > Select Project > Analysis > Counts Trend Comparison
You can compare the count trends for different dates. After setting the reference date and comparison date, select .
Using the count trend chart
In the count trend chart, you can use the following functions.
Select on the upper right of the screen. In the Layout Setting window, set it to 1 x 3 and then select Save. Time must be set to Last 24 hours. You can see the database key metrics in detail for the day, as follows:
-
If you click a specific time point of the metrics chart, the () area appears with red lines and the collected active sessions can be also displayed.
-
The active session data is collected every 5 seconds. You can search the data by selecting the 1-second cells at the bottom of the screen.
-
To move the time by 1 minute, select or .
-
To add or delete items in the detailed data cell, select . If the Column Setting window appears, you can add or delete any item.
-
Select the button and then apply a filter to the data cell header to sort only the desired data.
-
You can download the data displayed at the bottom of the screen as a CSV file. Select .
Lock tree
Home > Select Project > Analysis > Lock Tree
You can see the lock information. The structure of holders and waiters is expressed in a tree form. For more information about the lock tree analysis, see the following video clip.
Parallel query tree
Home > Select Project > Analysis > Parallel Query Tree
The parallel query information can be seen in a tree structure. The structures for Coordinator and Slave are presented in a tree form.
Database parameters
Home > Select Project > Analysis > Database Parameter
Parameter values in the database can be compared by date. The data of the current time can be seen by default. In Date, select a previous date and then click . To see the changes between the current time and the selected previous date, select View Changes.
For more information about Database Parameter, see the following video clip.