Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Turn off DPA table tuning advice for a table

Turn off DPA table tuning advice for a table

Table of contents

Updated September 11, 2018

Overview

In DPA you can disable table tuning and query advisors for individual queries, but you cannot automatically turn off advisors for all queries that run against a certain table. If you do not want to see table tuning advice for a table, you can disable advisors for each inefficient queries that runs on that table. 

Environment

  • DPA 12.0 and later

Steps

  1. Open a table tuning advisor for the table.
    The top-left pane lists all of the inefficient queries that ran against the table on the selected day. Information about the first query is shown in the top-right pane.
  2. Click the SQL hash or name in the top-right pane.
    SQL_hash.png
    The Query Detail page opens.
  3. In the top-right corner, click SQL Properties.
    The SQL Properties dialog opens.
  4. Deselect Enable advisor analysis.
    deselect.png
  5. Click the Back button in the DPA menu bar to return to the Table Tuning Advisor page.
  6. Select each query in the list and repeat the previous steps to disable advisors for all of them.

The next time DPA runs table tuning analysis, no advisors for these queries will be displayed. Repeat this procedure for any other inefficient queries that DPA discovers running against that table. 

 

 

Last modified

Tags

Classifications

Public