Versions Compared

Key

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

...

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

Configuring Active Queries view

You can change access the settings of Query activity data collection on the the Active Query Configuration screen. to Queries screen under the SSAS Performance category. To open the configuration window click Configuration 

...

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.

...