|
A Test Profile is a set of data collected by the Profiler. The data is collected as long as the Profiler is activated. The Profiler may collect data of screen actions that you perform as a user, but also of test executions that run while the Profiler is activated.
Open the Test Profiles tab or window by placing input focus on the "Test Profiles" item in the Database list view of USoft Benchmark's toolbox, and then pressing Enter (you can also double-click):
Once in the Test Profiles window, you need to query the data that you want to inspect.
Profile data, whether the result of interactive user behavior or test executions, are always collected on behalf of a specific user. A profile can be an element of a profile group. The default value for the Profile Group field is the name of the test; this is only the case if the profile is recorded as part of a test, otherwise the field is empty.
The Test Profiles tab shows a number of different time measurements. All times are in milliseconds:
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.
|
|
