Activity Monitor (Filter Properties Page)

  • Article

Use this page to reduce the number of rows visible in the Activity Monitor. Enter criteria in one or several of the available boxes, to show only the rows that meet the specified values. Some of the boxes, such as Status or Blocking Type offer a finite number of possible values, provided by a drop-down list. Others, such as Application, allow you to enter whatever value and as many values as you wish, as a comma separated list. Toolbar icons allow you to sort the available boxes by category or alphabetically. Click criteria to show a short description of the each one.

To filter the Activity Monitor, provide as many filter criteria as you want, click Apply filter, and then click OK.

Connection

This group of filter criteria is derived from the connections to SQL Server.

  • Host
    Name of the workstation connecting to SQL Server.
  • Show System Processes
    Select True to show system processes.
  • Application
    Name of the application program being used by the process.
  • Status
    Status of the process. Possible filter values are Background, Runnable, Running, and Sleeping. To stop filtering on status, select All.
  • User
    ID of the user who executed the command.
  • Processes
    SQL Server Process ID.

Resources

This group of filter criteria relates to the work being done on the SQL Server.

  • Blocking Type
    The blocked or blocking condition of the process. The available options are Blocked, Blocking, Blocked or Blocking, Blocked and Blocking, and All processes.
  • Database
    Database currently being used by the process. Filter for multiple databases by providing a comma separated list such as master, tempdb.
  • Waiting
    Select this criteria to monitor only those processes that are waiting to run. Possible values are only True or False.

  • Memory
    Provide an integer value. Filter for processes based on the number of pages in the procedure cache allocated to a given process. Enter a positive value to view only processes with at least that number of associated pages. Enter 0 to stop filtering using the Memory field.

    Note

    A process showing a negative value is freeing memory allocated by another process.

  • Open Transactions
    Filter for processes that have open transactions. Possible values are limited to Yes, meaning processes that have open transactions; No, meaning processes that do not have any open transactions; or All, meaning do not filter on the open transactions.

Description Area

  • Description Box
    This unnamed box provides a short description of the criteria as they are selected.
  • Apply filter
    To apply the filter, click Applyfilter and then click OK. To retain the filter settings in the FilterSettings dialog box, but not apply them, uncheck Applyfilter, and then click OK, to display all rows.
  • Clear filter
    Returns the filter settings back to the default settings.