SQL Log

SLXProfiler

previous page next page

SQL Log

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 SQL Log tab consists of the following values/columns:

Column

Description

Time Stamp

Time at which the query was executed.

SQL Type

Displays the type of query executed. Valid types are:

USER	all client queries
SYS_VSSC	VSSC internal queries (such as the IDs and page queries)
SYS_SECURITY	queries executed by the internal query engine
SYS_SCHEMA	queries executed by the data dictionary
SYS_PROC	queries executed by the internal stored procedures
SYS_KEYGEN	queries executed by the internal key generator

Parse

Time taken for the provider to internally parse the query.

Prepare(ms)

Time taken for the provider to internally prepare the query, which shows variances when the provider has to update its internal caches (like loading the schema information for the tables from the DB).

Execute(ms)

Time taken for the provider to execute the query against the DB server. (This does not include data retrieval time from the server.) This will show all the time taken for the DB server to actually execute the query. Long running queries will be highlighted here. This is especially evident when running queries on large tables where ORDER BY is used on non-indexed columns or where poor joins or bad query plans are used.

GetRows(ms)

Time taken to actually retrieve the data from the DB. This will show large numbers for large result sets.

Log(ms)

Time taken to prepare and generate the QUE file.

Rows

Number of rows retrieved for this query.

User ID

ACT! user code for the individual who executed this query.

Process ID

The ID of the ACT! application.

Machine

IP address of the machine on which the query was executed.

Client SQL

Column showing actual query executed by the client. This excludes all security joins and other additions.

The SQL statements that are captured will be color coded (the background of the row in the datagrid) by type of SQL statement.

SELECT statements are white
UPDATE statements are in yellow
DELETE statements are in gray
INSERT statements are in teal

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 will give a timestamp of 0.0000 to the next SQL statement that is captured.
You can copy whatever is in the grid by right-clicking on the grid, and then selecting Copy. This will allow you to paste the contents of the grid into Excel or a text editor in a tab separated format. In Excel, the columns will automatically be separated for you, including column headings.
If you would like 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 SQL Log tab

Numeric type:

timestamp
parse
prepare
secure
execute
getrows
log
rows
processid

String type:

userid
clientsql