Page History
...
Real time Query monitoring
Use the Enable option option to turn on or turn off this feature.
...
When you enable this option SQL BI Manager collects information only when queries cross one or more of these thresholds:
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. |
Rows Scanned in #rows | The number of rows a query reads. |
Retention period
This setting determines for how long SQL 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
...
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 >>
...
...