Page History
...
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 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
In the Active Queries view, the Configurtion To change the settings of how query activity data collection the In the Active Queries configuration you can perform the following actions:
You can The Configuration settings allow you to configure Query Monitoring to collect data constantly or collect data 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.
The Active queries screen provides information about queries collects query activity data constantly, you can change this setting
By default IDERA SQL Business Intelligence Manager monitors queries constantly, you can change this setting on the configuration section, other settings available in the configuration section are collection of poorly performing queries, set the location of log files, and set time periods for data retention.
The Active Queries screen provides information about query activity, the information is collected constantly, you can disable this on the configuration window.
To configure Query monitoring settings click Configure in the Active Queries view.
By default IDERA SQL Business Intelligence Manager v2.2 monitors queries constantly, you can change this setting on the configuration window
To change the query monitoring settings, click Configure in the Active Queries view.
The application will need to provide the ability to configure constant collection for queries, with the option to collect on long running queries, and save them for a specified period of time.
Advanced Query monitoring
When this option is enabled active queries data is collected constantly. if you disable itSQL BI collects query data constantly and other options are unavailable. If you disable Advanced Query Monitoring, SQL BI only collects data from 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 |
To collect information only on poorly performing queries, select the option poorly performing queries. When you enable this option the other options are disabled,
SQL Business Intelligence Manager identifies issues within the SQL BI environment to help optimize BI service performance. Learn more >>
...