Active Queries View
The Active Queries view provides relevant information about active queries on your environment. The available information consists of Account / User Name that started a query, Session SPID, the query's command text, start and end time of the query, elapsed time in milliseconds, CPU Time, reads and writes in kb.
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
The Configuration settings allow you to configure Query Monitoring to collect data constantly or at collection time only, collect data on all queries or collect data on poorly performing queries only, set the location of log files, and set time periods for historical data retention.
Advanced Query monitoring
When this option is enabled SQL BI collects query data constantly and other options are unavailable. If you disable Advanced Query Monitoring, SQL BI only collects active queries data at the time of collection.
Poorly performing queries
When you select this option IDERA SQL BIM only collects information on queries that cross a set threshold. You can set the following options:
| 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. |