Database Object Profiles

Database objects include stored procedures, functions, events, and triggers. Database object profile properties appear line by line, and summarize execution times.

Object Profile Properties.
Property name	Description
Calls	Lists the number of times the object has been called.
Milliseconds	Lists the total execution time for each object.
Line	Lists the line number beside each line of the procedure.
Source	Displays the SQL procedure, line by line.

Setting Database Profiling Properties in Sybase Central
Setting database profiling properties in Sybase Central requires DBA authority. Your server must be running, and you must be connected to a database.
Viewing Profiling Information For a Class of Database Objects
To display profiling information in Sybase Central about a class of database objects, click the parent folder, then review the object’s profile.
Viewing Profiling Information For a Specific Database Object
To display profiling information in Sybase Central about a specific database object, choose an object, then review the object’s profile.

Parent topic: Profiling Database Procedures

Created May 26, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com