SQL statement trace log (form)
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
Click System administration > Inquiries > Database > SQL statement trace log.
Use this form to view and analyze trace entities stored in the SysTraceTableSQL table.
Note
This form is available only if both the SQL trace option and the Table (database) option are selected in the Options form.
The following tables provide descriptions for the controls in this form.
Tab |
Description |
|---|---|
Overview |
Details about the trace entities, such as when they were created and by whom, the time it took to execute them, the type of trace, and the code that they were generated from. |
General |
General information about the Transact-SQL statement, such as the number of records that are affected, their size, the number of records retrieved for every fetch, reuse of the statement, statement ID, and connection ID. |
Description |
A description of the trace event, the SQL statement involved, and any additional information. |
Use |
The call stack that resulted in the trace incident. |
Tables |
All the tables that are referenced by the trace entry. The tables are listed by their Application Object Tree (AOT) names. |
Button |
Description |
|---|---|
Edit source code |
Edit the code in the Microsoft Dynamics AX code editor. |
Functions |
Access the Import, Export to, and Clear log options. |
Field |
Description |
|---|---|
Created date and time |
The date and time when the event was logged. |
User |
The user who created the event. |
Execution time |
The time that is spent executing the event. Execution time is in milliseconds. |
Trace type |
The object trace type: multiple SQL statement, query time, error, synchronize, deadlock, or warning. |
Code |
The numeric trace code that is specified by the trace event—for example, SQL error code or warning number. |
Large objects included |
If this option is selected, large objects from container or memo data type fields are returned by the statement. |
More data |
If this option is selected, more data is available after the statement is executed. |
Records affected |
The number of records in the database that are affected by the operation specified in the statement. |
Record size |
The amount of memory that is needed for Microsoft Dynamics AX to handle one record from the result set for this statement. |
Records per fetch |
The number of rows that are fetched during each Fetch operation. |
Selected for update |
If this option is selected, the statement was executed to select records for an update operation. |
Selected within transaction |
If this option is selected, the statement was executed from within a transaction. |
Reuses |
The number of times the statement is reused. |
Statement ID |
The internal identifier for the statement that is being traced. |
Statement type |
The type of statement: insert, update, or delete. |
Connection type |
The type of database connection used. There are six types of connections:
|
Database session ID |
The session ID of the Microsoft SQL Serverprocess that executed the statement. This ID is also shown in the Online users form. |
Connection ID |
The identification number of the database connection on which this statement was executed. |
Statement |
The Transact-SQL statements in the query. |
Text |
The description of the error from the database. |
Details |
Additional details about the specific trace log entry. |
Table ID |
The identification number of the table. |
Table name |
The unique name of the table. |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).