You can configure Query Monitoring to collect data constantly or collect data at collection time only, collect data on all queries or collect data on poorly performing queries only, set the location of log files, and set time periods for historical data retention.
To configure Query monitoring settings click Configure in the Active Queries view.
By default IDERA SQL Business Intelligence Manager v2.2 monitors queries constantly, you can change this setting on the configuration window
To change the query monitoring settings, click Configure in the Active Queries view.
The application will need to provide the ability to configure constant collection for queries, with the option to collect on long running queries, and save them for a specified period of time.