You can use dashboards to identify system bottlenecks on specific clusters and improve the performance of the system.
This is the multi-page printable view of this section. Click here to print.
Overview of Dashboards
This topic provides an overview of dashboards in OTCAD.
- 1: Dashboards
1 - Dashboards
This topic provides an overview of dashboards in OTCAD.
Dashboard
Dashboards enable you to view health metrics for your database.
Dashboard UI tour
You can view and manage dashboards. After signing in to the OTCAD application, the home page appears. Select the More options button and Dashboard. The Dashboard page appears as shown in this image:
Key considerations and events that include information about long running queries, average query execution time, and memory intensive queries is displayed at the right of the dashboard.
This page displays the following information:
| Option | Description |
|---|---|
| a | More options: Select this option to view the More menu options. |
| b | Dashboard: View the dashboards in OTCAD by different criteria. |
| c | Active users: This card displays the total number of users who are active over the last 24 hours. Select > to view the list of active users. For more information about active users, see Active users. |
| d | Data storage: This card displays the total or aggregate data storage in the database from the first day of the current month till date. |
| e | Query overview: This card displays the total count of queries that completed and the queries that failed to execute over the last 24 hours. |
| f |
Cluster performance: This card displays information about the overall cluster performance. It provides information about average CPU usage, average memory usage, and disk I/O usage over the last 24 hours.
|
| g |
Query insights: This card displays information about open sessions, queued queries, memory intensive queries, and long running queries.
|
Cluster performance
Expand Cluster performance in the Dashboard page. The following dashboards are displayed:
- CPU usage - The Average CPU Usage card displays information about the average cluster CPU usage trends in the system over a time duration. The Maximum Usage card displays information about the maximum CPU usage over a duration of time. Identify CPU usage and address system bottlenecks proactively.
In the Visualization tab, do the following:
-
In the Duration list, do one of the following:
- Choose the time duration in minutes, hours, or days for which you need to visualize the CPU usage history.
<--or-->
- Choose Custom. From the date pickers, select the start date and end date. Ensure that the start date does not exceed the end date by more than 30 days.
-
In the View list, choose one of the values: Average, Minimum, or Maximum. Choose Average to view the average CPU usage for every minute over the selected duration of time. Choose Minimum to view the minimum CPU usage for every minute over the selected duration of time. Choose Maximum to view the maximum CPU usage for every minute over the selected duration of time.
-
In the List view tab, information about the minute-wise time, average CPU usage, maximum CPU usage, and minimum CPU usage is displayed over the selected duration. Choose the Download button to export this information in a spreadsheet.
-
Memory usage - The Average Memory Usage card displays information about the average memory usage trends in the system over the selected duration. The Maximum Usage card displays information about the maximum memory usage over the selected duration of time. This helps you compare memory that OTCAD uses versus memory in use by the entire system. In the Visualization tab, do the following:
-
In the Duration list, do one of the following:
- Choose the time duration in minutes, hours, or days for which you need to visualize the memory usage.
<--or-->
- Choose Custom. From the date pickers, select the start date and end date for which you need to visualize the memory usage. Ensure that the start date does not exceed the end date by more than 30 days.
-
In the View list, choose one of the values: Average, Minimum, or Maximum. Choose Average to view the average memory usage for every minute over the selected duration. Choose Minimum to view the minimum memory usage for every minute over the selected duration of time. Choose Maximum to view the maximum memory usage for every minute over the selected duration of time.
-
In the List view tab, information about the minute-wise time, average memory usage, maximum memory usage, and minimum memory usage is displayed over the selected duration. Choose the Download button to export this information in a spreadsheet.
-
-
Disk I/O usage - The Disk I/O Usage card displays information about the disk I/O usage in the system over the selected duration. Identify and address disk I/O bottlenecks for resource optimization, capacity planning, and so on. The Maximum Usage card displays information about the maximum disk I/O usage over the selected duration. In the Visualization tab, do the following:
-
In the Duration list, do one of the following:
- Choose the time duration in minutes, hours, or days for which you need to visualize the disk I/O usage.
<--or-->
- Choose Custom. From the date pickers, select the start date and end date for which you need to visualize the disk I/O usage. Ensure that the start date does not exceed the end date by more than 30 days.
-
In the View list, choose one of the values: Average, Minimum, or Maximum. Choose Average to view the average disk I/O usage for every minute over the selected duration. Choose Minimum to view the minimum disk I/O usage for every minute over the selected duration of time. Choose Maximum to view the maximum disk I/O usage for every minute over the selected duration.
-
In the List view tab, information about the minute-wise time, average disk I/O usage, maximum disk I/O usage, and minimum disk I/O usage is displayed over the selected duration of time. Choose the Download button to export this information in a spreadsheet.
-
-
Scaling activity - View the utilization of additional compute units over the last 24 hours. Use this metric to identify and analyze the potential cost impact due to scaling. The Current Scale Instance card displays information about the current compute units in the system over the selected duration of time. The Maximum Scale card displays information about the maximum compute units over the selected duration of time. In the Visualization tab, do the following:
-
In the Duration list, do one of the following:
- Choose the time duration in minutes, hours, or days for which you need to visualize the scaling activity.
<--or-->
- Choose Custom. From the date pickers, select the start date and end date for which you need to visualize the scaling activity. You can select a start date that is more than one month prior to the end date.
-
In the List view tab, information about the date and time, scale event, compute (units), trigger, and user ID of the person who performed the scaling is displayed. Choose the Download button to export this information in a spreadsheet.
-
Query insights
Expand Query insights in the Dashboards page. The following dashboards are displayed:
-
Queries by duration - Analyze the count of queries that executed over the last 24 hours. Slow-running queries hinder overall database efficiency. Analyze the count of queries in the given interval by execution time. Only those queries that took more than 10 minutes to execute over the last 24 hours are displayed.
In the List view tab, information about the query, duration, and average memory usage is displayed. Choose the Download button to download this information in a spreadsheet. Mouse over the query results to view the details of the query. Select the Copy icon to copy the query to the clipboard.
-
Queries by memory usage - Analyze the count of queries over the last 24 hours by memory consumption. When a query uses a large share of memory, it can hinder the execution of other simultaneous queries by restricting access to shared resources.
In the List view tab, information about the query ID, average memory usage, and duration is displayed. Choose the Download button to download this information in a spreadsheet. Mouse over the query results to view the details of the query. Select the Copy icon to copy the query to the clipboard.
-
Queries in queue - Identify queries awaiting allocation of system resources in the last 1 hour.
In the List view tab, information about the initiation time, query ID, and time in queue is displayed. Choose the Download button to download this information in a spreadsheet. Mouse over the query results to view the details of the query. Select the Copy icon to copy the query to the clipboard.
System metrics
Expand System metrics in the Dashboards page. The following dashboards are displayed:
-
Sessions - Identify the total sessions over the last 1 hour to understand the database performance, identify bottlenecks, and optimize resource utilization.
In the List view tab, information about the session time, session type, session duration, client type, and user name is displayed. Choose the Download button to export this information in a spreadsheet.
-
Active users - Identify active users logged into the database over the last 24 hours.
In the List view tab, information about the user name, super user, roles, and last login time is displayed. Choose the Download button to export this information in a spreadsheet.