The Profiling Results tab provides a summary of the profiling information for all the objects, grouped by type, that have been executed within the database since you started procedure profiling. The information displayed includes:
Column | Description |
---|---|
Name | The name of the object. |
Owner | The owner of the object. |
Table or Table Name | The table a trigger belongs to (this column only appears on the database Profile tab). |
Event | The type of object, for example, a procedure. |
Type | The type of trigger for system triggers. This can be Update or Delete. |
# Execs. | The number times each object has been called. |
# msec. | The total execution time for each object. |
These columns, and their content, may vary depending on the type of object.
When you double-click a specific object, such as a procedure, details specific to that object appears in the Profiling Results tab. The information displayed includes:
Column | Description |
---|---|
Execs | The number of times the line of code in the object was executed. |
Milliseconds | The total amount of time that a line took to execute. |
% | The percent of total time that a line took to execute. |
Line | The line number within the object. |
Source | The code that was executed. |
Lines with long execution times compared to other lines in the code should be analyzed to see whether there is a more efficient way to achieve the same functionality. You must be connected to the database, have profiling enabled, and have DBA authority to access procedure profiling information.
Analyzing procedure profiling results
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |