Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

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