analyze-performance

To identify query performance bottlenecks in Teradata, analyze throttle statistics, query logs, and resource metrics to pinpoint issues like excessive throttling or inefficient queries. This process distinguishes symptoms from root causes across queries and workloads.

Workload management performance analysis is used to diagnose system performance issues by examining resource utilization and throttle statistics. It helps identify optimization opportunities and supports proactive performance reviews or SLA violation investigations.

You investigate SLA violations using system resource metrics by correlating data from multiple sources like query logs and throttle statistics. This correlation distinguishes symptoms from root causes to determine why queries execute slowly and breach SLAs.

Yes, you can get optimization recommendations for slow query execution. The analysis suggests specific actions to improve system efficiency, such as adjusting workload priorities after evaluating resource utilization and throttle statistics.

Performance analysis works for both overall system resources and individual queries. Scopes include queries, sessions, workloads, and overall system resources, allowing you to diagnose performance issues across multiple levels simultaneously.

The best way to conduct a proactive performance review is to analyze system performance over a specific period, such as the past month. Examining throttle statistics and resource metrics identifies top performance issues and provides actionable recommendations.