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: | ||||||||||||
| |||||||||||||
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