Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Database Performance » Monitoring and improving performance » Application profiling » Procedure profiling in Application Profiling mode

 

Enabling procedure profiling

Once procedure profiling is enabled, the database server gathers profiling information until you disable profiling or until the database server is shut down.

To enable procedure profiling (Sybase Central)

  1. Connect to the database as a user with DBA authority or as a user with PROFILE authority.

  2. In the left pane, select the database.

  3. From the Mode menu, choose Application Profiling.

  4. Follow the Application Profiling Wizard instructions.

    If the Application Profiling Wizard does not appear, choose Application Profiling » Open Application Profiling Wizard.

  5. On the Profiling Options page, select Stored Procedure, Function, Trigger, Or Event Execution Time.

  6. Click Finish.

    If you switch to another mode, a prompt appears asking whether you want to stop collecting procedure profiling information. Select No to continue working in other modes while profiling continues.

See also
Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0