Details

  • Updated on Apr 9, 2025
  • Published on Nov 9, 2023
  • 6 minute(s) read
Prev Next

Activity Details

This card displays the result counts and their aggregate values or subsets at the time of collection for a single Instance in a table format with sortable columns, as follows:

  • Use the drop-down menus to further filter the list by Instance, Database, Login, Program, Wait Category, and Wait Type.
  • The Date Range column displays the times covered during data collection. Data is collected by the minute for the current 24-hour day and is displayed by row in three (3) hour increments for the selected Instance. Click the calendar widget to change to a previous date.
    • To break down each three (3) hour increment further, click the Date Range field for that row. The range can be decreased to one (1) hour, 15-minute, 5 minute and one (1) minute intervals.
      • The specified interval range is displayed in the Instance identifier line above the table. To restore previous intervals, click the respective link.
  • The Batch Requests (P90) column displays the 90th percentile count of batch requests observed during the time interval.
  • The Parallel Threads column displays the number of threads active on the CPU during the selected time interval. Parallel queries can use more CPU time than actual elapsed time and, due to blocking, the elapsed time may be longer than the total amount of CPU time.
  • The Blocked Processes column displays the count of blocked processes observed during the time interval.
  • The Deadlocks column displays the count of deadlocks observed during the time interval.
  • The Wait Time column displays the total wait time observed during the time interval.
  • The CPU column displays the total time queries spent on the CPU during the time interval. Note that this is cumulative across cores and parallel threads and will often exceed the duration of the interval itself.
  • The IO column displays the total logical IO observed for queries running in the time period.
  • The Total Sessions column displays the count of sessions observed during the time interval.
  • The Observations column will display an Eyeball icon and a number if WISdom has detected related performance conditions such as High CPU Usage, High IO Usage, High Session Count, High Blocking, or High Wait time. Click the icon to view the observations for the time interval.
Sorting

Click the column headings to sort the list in ascending or descending

View Details Flyout

This card provides three (3) ways to further examine the data collected for a specific time interval, as follows:

  • Resources
  • Wait Statistics
  • Applications

See the following sections for more information on viewing Result Count details.

Resources

By default, Resource data aggregated from the Result Counts at the time of collection for a single Instance is grouped in a table format with sortable columns, as follows:

  • The Time column displays the collection time in one (1) minute intervals.
  • The Session ID (SPID) column displays the database connection IDs for each (single logged-on) session in the DMVs.
  • The Run Time column displays the actual amount of time a query spent in a running state.
  • The Database column displays the name of the database the query was running against.
  • The Status column displays the current state of the transactions at the time of collection on the CPU.
    • Some possible statuses are:
      • Runnable – in queue waiting for its turn on the CPU
      • Running – currently active on the CPU
      • Suspended – waiting on some resource to complete execution
      • Rollback - a specific transaction or transaction set has been canceled, any changes made have been undone, and the database has been restored to a previous state
  • The Blocked by column displays the number of queries that were blocked during the selected time interval by Blocking ID.
  • The Parallel Threads column displays the number of threads active on the CPU during the selected time interval. Parallel queries can use more CPU time than actual elapsed time and, due to blocking, the elapsed time may be longer than the total amount of CPU time.
  • The CPU column displays the duration for a query to complete execution.
  • The IO column displays the accumulated number of reads per Session ID and is used for evaluating query and batch I/O performance when an SQL Server reads data from the memory.
  • The SQL Statement column displays the corresponding SQL Statement, which can be copied and exported.

Note: Click on the column headings to sort the list in ascending or descending order.

Group By

This data on Resources be further examined by using the Group By drop-down menu, as follows:

The data can be grouped by Database, Status, or SQL Statement.
Displays a sortable list by Database, Runtime, CPU, and IO.

  • Click the arrow > to the left of the row to see details for a specific database by Time, Session ID, Runtime, Status, Blocked by, Parallel Threads, and SQL Statement.

Wait Statistics

By default, Wait Statistics subsets aggregated from the Result Counts at the time of collection for a single Instance are grouped in a table format with sortable columns, as follows:

  • The Time column displays the collection duration in one (1) minute intervals.
  • The Runtime column displays the amount of time a query spent in a running state on the CPU.
  • The Database column displays the name of the database where the resource resides.
  • The Status column displays the current state of the transactions at the time of collection on the CPU.
    • Some possible statuses are:
      • Runnable – in queue waiting for its turn on the CPU
      • Running – currently active on the CPU
      • Suspended – waiting on some resource to complete execution
      • Rollback - a specific transaction or transaction set has been canceled, any changes made have been undone, and the database has been restored to a previous state
  • The Wait Type column displays the wait performed to execute the task created by SQL Server.
  • The Wait Time column displays how much time the database spent actually completing operations.
  • The SQL Statement column displays the corresponding SQL Statement, which can be copied and exported.

Note: Click on the column headings to sort the list in ascending or descending order.

Group By

This data on Resources be further examined by using the Group By drop-down menu, as follows:

The data can be grouped by Database, Status, Wait Type, Wait Resource, or SQL Statement.
Displays a sortable list by Group By value, Run Time, and Wait Time.

  • Click the arrow > to the left of the row to see details for a group by Time, Session ID, Run Time, Status, Wait Type, Wait Resource, Wait Time, and SQL Statement.

Applications

By default, Resource data aggregated from the Result Counts at the time of collection for a single Instance is grouped in a table format with sortable columns, as follows:

  • The Time column displays the collection time in one (1) minute intervals.
  • The Session ID (SPID) column displays the database connection IDs for each (single logged-on) session in the DMVs.
  • The Run Time column displays the actual amount of time a query spent in a running state.
  • The Database column displays the name of the database the query was running against.
  • The Status column displays the current state of the transactions at the time of collection on the CPU.
    • Some possible statuses are:
      • Runnable – in queue waiting for its turn on the CPU
      • Running – currently active on the CPU
      • Suspended – waiting on some resource to complete execution
      • Rollback - a specific transaction or transaction set has been canceled, any changes made have been undone, and the database has been restored to a previous state
  • The Host column displays the origin host for the request.
  • The Login column displays the login that ran the request.
  • The Program Column displays the Application context from the connection string.
  • The SQL Statement column displays the corresponding SQL Statement, which can be copied and exported.

Note: Click on the column headings to sort the list in ascending or descending order.

Group By

This data on Resources be further examined by using the Group By drop-down menu, as follows:

The data can be grouped by Database, Status, Host, Login, Program, or SQL Statement.
Displays a sortable list by Database, Runtime, CPU, and IO.

  • Click the arrow > to the left of the row to see details for a specific database by Time, Session ID, Run Time, Status, Host, Login, Program, and SQL Statement.