Page History
Active Queries View
The Active Queries view provides relevant information about active queries on your environment. You can find the following information:
- Account / User Name that started a query
- Session SPID
- Query's command text
- Start and end time of the query
- Elapsed time in milliseconds
- CPU Time
- Reads and writes in kb.
...
- 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 collection.
Enabled: SQL BI Manager collects query data constantly. When this option is enabled SSAS performance can be affected.
Disabled: SQL BI Manager collects query data at the time of collection using the current query data collection method.(set on the Manage Monitored Services screen)?????
Poorly performing queries
| Info |
|---|
To use these settings you must enable real time query monitoring. |
When you select enable this option IDERA SQL BIM only BI Manager collects information from only when queries that cross one or more of these thresholds:
...
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).
Location of log files
...