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:
- Enable 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.
Real time Query monitoring
Use the Enable option to determine the frequency of data collectionturn on or turn off this feature.
Enabled: SQL BI Manager collects query data constantly. When this option is enabled While query monitoring has minimal overhead, SSAS performance can could be affected.
Disabled: SQL BI Manager collects query data at the time of collection using the current query data collection method.(The RefreshInterval? default 6min? The instances refresh interval determines how often query data is collected.(set under Manage Monitored Services )
...
| Duration in milliseconds | Time in milliseconds after which a query is considered poorly performing. |
| CPU time in milliseconds | How much CPU time a query uses CPU. |
| Rows Scanned in #rows | The number of rows a query reads. |
...
This setting determines for how long 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). Depending on query activity, longer retention periods will cause the repository database to grow significantly
Location of log files
This is the path where IDERA SQL BIM stores log files, the default path is the same as the SSAS log files location. to set another path use the UNC format for example \\<server name>\c$\Program Files\Microsoft SQL Server\MSAS12.MSSQLSERVER\OLAP\Log. Make sure that the account used for data collection has permissions for accessing and writing to the log files directory.
...