Page History
...
Configuring the Active Queries view
On the Active Queries screen, click Configuration to change the query monitoring settings. On the configuration screen you can change the following settings:
To change the query activity data collection settings, click Configuration on the Active Queries screen. On the configuration screen you can change the following settings:
- Frequency of data collectionEnable real time query query monitoring.
- Collect data from all queries or from poorly performing queries only.
- Set the location of log files.
- Set time periods for historical data retention.
Advanced Query monitoring
Use the Advanced Query monitoring option Enable option to determine the frequency of data collection.
Enabled: SQL BI Manager collects query data constantly. . When this option is enabled SSAS performance can be affected.
Disabled: SQL BI only Manager collects query data at the time of collection using the current query data collection method.(set on the Manage Monitored Services screen)?????
...
This setting determines for how long IDERA SQL BIM SQL BI Manager retains historical data, the default retention period is one day. To set a time period type a number in the first field and select a value from the dropdown (min, hours, days, weeks, months).
SCREEN
Location of log files
...