Procedure profiling provides you with different information depending whether you choose to look at information for your entire database, a specific type of object, or a particular procedure. The information can be displayed in the following ways:
details for all profiled objects within the database
details for all stored procedures and functions
details for all events
details for all triggers
details for all system triggers
details for individual profiled objects
You must be connected to your database and have profiling enabled to view profiling information.
When you view profiling information for your entire database, the following columns appear:
Table Lists which table a trigger belongs to (this column only appears on the database Profile tab).
Event Shows the type of trigger for system triggers. This can be Update or Delete.
These columns provide a summary of the profiling information for all of the procedures that have been executed within the database. One procedure can call other procedures, so there may be more items listed than those users call specifically.
To view summary profiling information for stored procedures
and functions
Select the Procedures & Functions folder in the left pane.
Click the Profile tab in the right pane.
Profiling information about all the stored procedures and functions within your database appears on the Profile tab.
To
view summary profiling information for events
Open the Events folder in the left pane.
A list of all the events in your database appears on the Events tab in the right pane.
Click the Profile tab in the right pane.
Profiling information about all of the events within your database appears on the Profile tab.
To
view summary profiling information for triggers
Open the Triggers folder in the left pane.
A list of all the triggers in your database appears on the Triggers tab.
Click the Profile tab in the right pane.
Profiling information about all of the triggers in your database appears on the Profile tab.
To view summary profiling information for system triggers
Open the System Triggers folder in the left pane.
A list of all the triggers in your database appears on the System Triggers tab.
Click the Profile tab in the right pane.
Profiling information about all of the system triggers in your database appears on the Profile tab.
Sybase IQ provides procedure profiling information about individual stored procedures, functions, events, and triggers. Sybase Central displays different information about individual procedures than it does about all of the stored procedures, functions, events, or triggers within a database.
When you look at the profiling information for a specific procedure, the following columns appear:
Milliseconds Lists the total execution time for each object.
Line Lists the line number beside each line of the procedure.
The procedure is broken down line by line and you can examine it to see which lines have longer execution times and therefore might benefit from changes to improve the procedure's performance. You must be connected to the database, have profiling enabled, and have DBA authority to access procedure profiling information.
To view the profiling information for a stored procedure
or function
Expand the database in the left pane.
Select the Procedures and Functions folder in the left pane.
A list of all the stored procedures and functions within your database appears on the Procedures & Functions tab in the right pane.
Click the stored procedure or function you want to profile in the left pane.
Click the Profile tab in the right pane.
Profiling information about the specific stored procedure or function appears on the Profile tab in the right pane.
To view profiling information for an event
Expand the database in the left pane.
Select the Events folder in the left pane.
A list of all the events within your database appears on the Events tab in the right pane.
Click the event you want to profile in the left pane.
Click the Profile tab in the right pane.
Profiling information about the specific event appears on the Profile tab in the right pane.
To view profiling information for triggers
Expand the database in the left pane.
Open the Triggers folder in the left pane.
A list of all the triggers appears on the Triggers tab in the right pane.
Select the trigger you want to profile in the right pane.
Click the Profile tab in the right pane.
Profiling information about the specific trigger appears on the Profile tab in the right pane.
To view profiling information for system triggers
Expand the database in the left pane.
Open the System Triggers folder in the left pane.
A list of all the system triggers appears on the System Triggers tab in the right pane.
Select the system trigger you want to profile in the right pane.
Click the Profile tab in the right pane.
Profiling information about the specific system trigger appears on the Profile tab in the right pane.
