Viewing statements in a monitor

Right-click any detailed monitor in the SQL performance monitor window and select Show statements.

The filtering options provide a way to focus in on a particular area of interest:

Minimum runtime for the longest execution of the statement:

Select to include statements that exceed a certain amount of time. Select a number and then a unit of time.

Statements that ran on or after this date and time:

Select to include statements run at a specified date and time. Select a date and time.

Statements that reference the following objects:

Select to include statements that use or reference certain objects. Click Browse to select objects to include.

Statements that contain the following text:

Select to include only those statements that contain a specific type of SQL statement. For example, specify SELECT if you only want to include statements that are using SELECT. The search is case insensitive for ease of use. For example, the string 'SELECT' finds the same entries as the search string 'select'.

Multiple filter options can be specified. In a multi-filter case, the candidate entries for each filter are computed independently. Only those entries that are present in all the candidate lists are shown. For example, if you specified options Minimum runtime for the longest execution of the statement and Statements that ran on or after this date and time, you will be shown statements with the minimum runtime that ran on or after the specified date and time.