Page History
...
Advanced Query monitoring
Use the Advanced Query monitoring option to determine the frequency of data collection. When you enable this option the other settings are unavailable (when you select...) Selecting this option disables other options on the same screen.
Enabled: SQL BI collects query data constantly.
Disabled: SQL BI only collects query data at the time of collection using the current query data collection method.
When you enable this option, active query data collection is constant. If you disable Advanced Query Monitoring, SQL BI only collects active queries data at the time of collection.(set on the Manage Monitored Services screen)?????
Poorly performing queries
When you select this option IDERA SQL BIM only collects information on from queries that cross a set threshold. You can set the following one or more of these thresholds:
| Duration in milliseconds | Set a time 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 setting to determine for how long IDERA SQL BIM retains historical data for query monitoring.. To set a time period type a number in the first field and select a value from the dropdown (min, hours, days, weeks, months). the default retention period is one day. ??????????
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.
...