Investigate performance issues with DPA
DPA uses an approach called wait-based analysis to help you focus on issues that provide the greatest performance improvements. Query advisors and table tuning advisors identify performance issues and help you find the root cause. Anomaly detection identifies queries with wait times significantly higher than normal.
See the following topics for information about using DPA to investigate performance issues:
The DPA Getting Started Guide includes walk-through examples of using DPA to investigate performance problems: