Exclude SQL statements from DPA charts and analysis
Certain long-running SQL statements might not be candidates for tuning (for example, SQL statements associated with database backups or replication).
-
If the bar representing a long-running SQL statement is dominating the trend charts and making other bars difficult to see, you can exclude the SQL statement from trends charts.
- To prevent DPA from generating query advisors for the SQL statement or considering it when generating table tuning advisors, you can disable advisor analysis for the statement.
Complete the following steps to exclude the statement from charts or disable analysis.
-
In any chart legend, click the name or hash value that represents the SQL statement.
The Query Details page displays information about the SQL statement.
-
In the top-right corner, click SQL Properties.
The SQL Properties dialog opens.
-
Under Advanced Settings, clear one or both of the following options:
-
Clear the Show in Trends charts setting to remove the SQL statement from multi-day or one-day trend charts. If you drill in to a time period less than one day, charts include the SQL statement.
-
Clear the Enable advisor analysis setting to exclude this statement from the analysis that DPA runs to generate query advisors and table tuning advisors. When analysis is disabled, DPA does not detect problems with the SQL statement.
When you clear the Show in Trends charts setting, both options are cleared by default. To clear only the first option, click Enable advisor analysis to re-select it.
-
- Click Save.
You can add excluded SQL statements back at any time.