Overview of Dashboards

• 1: Dashboards

1 - Dashboards

Dashboards

Dashboards enable you to view health metrics for your database.

Dashboards 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:

The dashboard displays key metrics and events, including details about long-running queries, average query execution time, and memory-intensive queries.

This page displays the following information:

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:

1. In the Duration list, do one of the following:

   • Choose the time duration in minutes, hours, or days 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.

2. 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.

3. 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:

1. In the Duration list, do one of the following:

   • Choose the time duration in minutes, hours, or days 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.

2. 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.

3. 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:

1. In the Duration list, do one of the following:

   • Choose the time duration in minutes, hours, or days 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.

2. 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.

3. 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:

1. In the Duration list, do one of the following:

   • Choose the time duration in minutes, hours, or days 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.

2. 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 Download 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. This dashboard displays only those queries that took more than 10 minutes to execute over the last 24 hours.

  In the List view tab, information about the query, duration, and average memory usage is displayed. Choose Download to export this information in a spreadsheet. Hover 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 Download to export this information in a spreadsheet. Hover 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 Download to export this information in a spreadsheet. Hover 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 Download 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 Download to export this information in a spreadsheet.