Procedure profiling tracks the usage of procedures and triggers by all connections. You can enable profiling in either Sybase Central or Interactive SQL. You must have DBA authority to enable and use procedure profiling.
To enable profiling (Sybase Central)
Connect to your database as a user with DBA authority.
Select the database in the left pane.
From the File menu, choose Properties.
The Database property sheet appears.
On the Profiling tab, select Enable Profiling on This Database.
Click OK to close the property sheet.
You can also right click your database in Sybase Central to enable profiling. From the popup menu, choose Profiling > Start Profiling.
Connect to your database as a user with DBA authority.
Call the sa_server_option stored procedure with the ON setting.
For example, enter:
CALL sa_server_option ( 'procedure_profiling', 'ON')
If necessary, you can see what procedures a specific user is using, without preventing other connections from using the database. This is useful if the connection already exists, or if multiple users connect with the same userid.
To filter procedure profiling by user
Connect to the database as a user with DBA authority.
Call the following procedure:
CALL sa_server_option ('ProfileFilterUser','userid')
The value of userid is the name of the user being monitored.
