Recent Expensive Queries and Active Expensive Queries

The last two sections are very similar to each other and both show the list of the most expensive queries with statistical information. The Recent Expensive Queries section shows statistics about finished queries and the Active Expensive Queries section shows queries actually running.

Both sections are depicted in the following screenshot:

The Recent Expensive Queries section shows the following:

  • Number of executions per minute: How many times the query was executed during a minute
  • Amount of milliseconds spent by the query on CPUs per second: Ratio of time spent on CPU in every minute ...

Get SQL Server 2017 Administrator's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.