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:

The DPA Getting Started Guide includes walk-through examples of using DPA to investigate performance problems: