All Messages

SLXProfiler

All Messages

When you profile an application, the Profiler Log window is populated with all of the captured events. These events are listed as a series of execution timings (in milliseconds). The All Messages tab shows the combined output of the SQL Log Tab and Error Log Tab in a summary format.

The All Messages tab consists of the following values/columns:

Column

Description

Time Stamp

Time at which the query was executed.

Message Type

Indicates whether the query returned SQL or an Error Message.

Process ID

The ID of the ACT! application.

Machine

IP address of the machine on which the error occurred.

Message

Displays the text of the SQL or Error Message.

Captured Error statements are highlighted in red.

Additional features

  • You can clear the grid by right-clicking on the grid, and then selecting Clear from the pop-up menu.

  • You can reset the timestamp by right-clicking on the grid, and then selecting Reset Timestamp. This gives a timestamp of 0.0000 to the next SQL statement that is captured.

  • You can copy the content of the grid by right-clicking on the grid, and then selecting Copy. This allows you to paste the contents of the grid into Excel or a text editor in a tab separated format. In Excel, the columns are automatically separated for you, including column headings.

  • If you want to ‘pause’ the capturing of the SQL statements, click the Pause Profiling button on the toolbar. When you want to resume, click the button again.

  • You can filter which SQL statements are captured by using a filter through the use of regular expressions. This is a non-destructive filter so the information is not lost.

The following filter variables are available on the All Messages tab

Numeric type:

  • timestamp

  • processid

String type:

  • messagetype

  • message

Related Topics

Set Filter

SQL Log

Error Log