Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register Now.

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: 233 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

Tags

Classifications

Public