View resource metrics in DPA

Resource metrics provide information about how resources (such as CPU, disk, and memory) are being used at specific points in time. These metrics show what was happening in the rest of your environment during database slow-downs, and can provide context to help you identify the root cause of performance problems.

DPA displays resource metrics in the following locations.

View all available metrics on the Resources tab

The Resources tab displays all available resource metrics for the selected database instance.

  1. On the DPA homepage, click a database instance to view detailed information.
  2. In the upper-right corner, click the Resources tab.

    The Resources tab displays all available resource metrics for the selected database instance. You can:

    • Click a time period in the upper-right corner to change the time range.
    • Show or hide baselines.
    • Click the Information link to display information about a metric.
    • Click Settings to view or change the thresholds for that metric.

Correlate wait time with resource metrics on the Trends tab

When you are viewing wait time charts on the Trends tab, you can scroll down to determine if unexpectedly long wait times correlate with resource contention.

  1. On the DPA homepage, click a database instance to view detailed information.
  2. In the upper-right corner, click the Trends tab.

  3. Scroll down and click the Resources tab below the wait time charts.

    The Resources tab displays a subset of the available resource metrics for the selected database instance. You can:

    • Click Add Resource Chart to include additional charts.
    • Click to display information about a metric.
    • Click to view or change the thresholds for that metric.
    • Use other icons to the right of a chart to remove it, change its location, or replace it with a different chart.

View resource metrics related to the performance of a query

To help you find the root cause of long wait times for a query, the Query Details page includes the most relevant statistics, blocking, plan, and metrics charts. When you scroll down to view these charts, the Top Waits chart at the top of the page remains visible so you can correlate query wait times with other events during the same time period.