Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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 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.

...

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.

...