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

 

Related Topics

Set Filter

All Messages Tab

Error Log Tab