Typical Tasks for Maximizing Database Performance

Here’s a list of tasks to analyze the performance of your databases using Database Performance Analytics.

Task	Description	More Information
Analyze database performance degradation and access workload stability.	Identify the databases that have degraded in performance. Identify negative correlations between performance trends and demand. Identify the databases that have varying performance.	Analyze Database Performance Degradation
Analyze the SQL statements with highly varying performance and the top SQL statements.	Identify SQL statements that are varying highly in performance. Identify the top SQL statements across your entire databases environment.	Analyze SQL Execution Performance
Analyze workloads with unusual characteristics.	Analyze database inefficiency.	Analyze Database Inefficiency
Analyze SQL performance	Identify degrading SQLs, variant SQLs, inefficient SQLs, and SQLs with multiple execution plans across databases.	Analyze SQL Performance