Time

Meaning

Elapsed Time

The total elapsed time, measured from the moment the first execution element is started until the moment the last execution element is finished. A profile that has not yet been prepared will only contain this time.

SQL Manipulation Time

The time used for executing and evaluating all data manipulation SQL Statements within the profile.

Manipulation Overhead Time

The time used for manipulation overhead other than manipulation SQL . For example: rearranging and optimizing constraint order, and evaluating which constraints should be evaluated.

Total Manipulation Time

The total time used for performing data manipulations. The total manipulation time is the sum of the SQL manipulation time and the manipulation overhead time.

SQL Other Time

The time used for other SQL queries other than manipulation SQL. Examples include underlying queries, extra queries, decisions and SqlScript methods within the profile.

Other Overhead Time

The time used to record the profiler, profiler overhead time and the time to perform user actions like pushing a button, selecting a menu etc. This is the time that is not used for manipulations and SQL.

Total Other Time (SQL Other Time + Other Overhead Time)

The total other time SQL is the sum of the SQL other time and the other overhead time. This is the time used for SQL queries other than manipulation SQL and profile recording time, profile overhead time and performing user actions.

Total SQL Time

The total time used for executing all SQL statements within the profile. The Total SQL time is the sum of the SQL manipulation time and the SQL other time.

Total Overhead Time (Manipulation Overhead Time + Other Overhead Time)

The total overhead time is the sum of the manipulation overhead time and the other overhead time. This is the time used for manipulation overhead other than manipulation SQL and profile recording time, profile overhead time and performing user actions.