Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance » Other diagnostic tools and techniques » Procedure profiling using system procedures

Procedure profiling using system procedures Next Page

Enabling profiling using sa_server_option


This section explains how to enable procedure profiling from Interactive SQL using the sa_server_option system procedure.

For more information on the syntax of, and results returned by, this system procedure, see sa_server_option system procedure.

You must have DBA authority to enable and use procedure profiling.

To enable procedure profiling in Interactive SQL
  1. Connect to your database as the DBA.

  2. Call the sa_server_option system procedure, setting the ProcedureProfiling option to ON.

    For example, enter:

    CALL sa_server_option( 'ProcedureProfiling' , 'ON' );
  3. 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 user ID.

    To filter procedure profiling by user in Interactive SQL
    1. Connect to the database as the DBA.

    2. Call the sa_server_option system procedure as follows:

      CALL sa_server_option( 'ProfileFilterUser' , 'userid' );

      The value of userid is the name of the user being monitored.