When to use SQL Activity reports

Use SQL Activity reports to resolve performance problems with applications or queries that cannot be resolved by using the Accounting or Explain reports.

These are most commonly problems with scan and sort activity. To isolate the problem, you need to run an SQL Activity trace, which shows the workload for sort.