|
See Also
The View on Manipulation
window shows statistic timing information about a specific
manipulation. This window can be viewed by clicking the View
Manipulation button on the Manipulations tab page in the Test
Profiles window.
The timing characteristics are
divided into single manipulation information and related
manipulation information. The 'Related Manipulation' fields present
the timing characteristics of manipulations started due to SQL
statements within this manipulation.
The information about the
timing characteristics of SQL statements handled on the client and
on the server depends on whether the SQL statement is optimized, or
not. If SQL Statements are optimized they are processed on the
client computer; if they are not optimized they are sent to the
database server.
The View on Manipulation window
This table lists the meaning
of all Specific and Related manipulation fields (reading from left
to right). All times are in milliseconds.
|
Field
|
Meaning
|
|
Time
|
The time used performing the data manipulation. This is the time
used for executing all SQL Statements within the manipulation plus
the time used for manipulation overhead other than manipulation
SQL. For example: rearranging and optimizing constraint order, and
evaluating which constraints should be evaluated.
|
|
SQL Time
|
The time used for executing and evaluating the SQL statements
within the manipulation. This time can be divided into time used
for SQL handled on the client and time used for SQL handled on the
server; it is the sum of these two times.
|
|
Number of SQL
|
The number of SQL statements executed within the manipulation.
This number can be divided into a number of SQL statements handled
on the client and a number of SQL statements handled on the server;
it is the sum of these two numbers.
|
|
SQL Client Time
|
The time used for executing the SQL statements handled on the
client within the manipulation.
|
|
Number of SQL Client
|
The number of executed SQL statements handled on the client
within the manipulation.
|
|
SQL Server Time
|
The time used for executing the SQL statements handled on the
server within the manipulation.
|
|
Number of SQL Server
|
The number of executed SQL statements handled on the server
within the manipulation.
|
|
Total Time
|
The time used performing the specific data manipulation plus the
time used to perform the related manipulations which are started
due to SQL statements within the manipulation.
|
|
Total SQL Time
|
The time used for executing and evaluating the SQL statements
within the manipulation plus the time used for executing and
evaluating SQL Statements of related manipulations which are
started due to SQL statements within the manipulation.
|
|
Total Number of SQL
|
The number of SQL statements executed within the manipulation
plus the number of SQL statements executed within the related
manipulations which are started due to SQL statements within the
manipulation.
|
|
