Page History
...
You can change the settings of Query activity data collection on the Active Query Configuration screen. to open the configuration window click Configuration
Configuring Active Queries view
...
When you select this option IDERA SQL BIM only collects information on queries that cross a set threshold. You can set the following optionsthresholds:
Duration in milliseconds | Set a time in milliseconds after which a query is considered poorly performing. | |
CPU time in milliseconds | How much time a query uses CPU. | |
Rows Scanned in #rows | The number of rows a query reads. |
Retention period
You can use this settings to determine for how long IDERA SQL BIM retains historical data for query monitoring.
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.
SQL Business Intelligence Manager identifies issues within the SQL BI environment to help optimize BI service performance. Learn more >>
...