Submit a ticketCall us

Welcome to the NEW Success Center. Search all resources (documentation, videos, training, knowledge base articles) or browse resources by product. If you are unable to find what you are looking for, please contact us at customersuccess@solarwinds.com

 

 

 

 

Home > Success Center > Database Performance Analyzer (DPA) > Exclude a SQL Statement from DPA data collection

Exclude a SQL Statement from DPA data collection

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 976 Votes: 0 Revisions: 9

 

It may be helpful to exclude SQL statements from the DPA performance data collection module. For example, you can exclude SQL statements associated with backups, replication, and so on.

 

  1. Click Options > Support > Database Query Tool.
  2. You need the DPA ID for the database instance and the DPA ID for the SQL statement you want to exclude.

 

DPA database instance ID

select ID, name from cond;

Copy and paste the ID value into the INSERT statement below replacing the <dbid> placeholder.

 

DPA ID for SQL statement

In DPA, click the SQL statement where it appears in one of the legends. You will see the SQL text along with the ID (Hash) for the statement. Copy and paste that number into the INSERT statement below replacing the <sql> placeholder.

 

INSERT the SQL into CON_QP_EXCLUDE (8.1 and earlier)

INSERT INTO con_qp_exclude (dbid, type, value) VALUES (<dbid>, 'H', '<sql>');

 

INSERT the SQL into CON_QP_EXCLUDE (8.1 and later)

INSERT INTO con_qp_exclude (dbid, type, value, origin) VALUES (<dbid>, 'H', '<sql>', 'U');

 

All future data collection will exclude this SQL statement.  No past data will be purged as a result, but the SQL statement will eventually age out of all charts in DPA.

Last modified
19:14, 22 Jun 2016

Tags

Classifications

Public