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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Performance monitoring and diagnostic tools » Application profiling » Procedure profiling results

 

Analyzing procedure profiling results

You can view profiling results for stored procedures, user-defined functions, triggers, system triggers, and events in your database.

Prérequis

You must have the DIAGNOSTICS system role, and the MANAGE PROFILING, SERVER OPERATOR, and SELECT ANY TABLE system privileges.

 Task
  1. In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.

  2. Enable procedure profiling:

    1. Click Mode » Application Profiling.

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

    2. Follow the instructions in the Application Profiling Wizard.

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

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

  3. In the left pane, double-click one of the following: Triggers, System Triggers, Procedures & Functions, or Events.

  4. In the right pane, click the Profiling Results tab.

    A list appears of all the objects of the selected type that have executed since you enabled procedure profiling.

    An expected object might be missing because it has not been executed. Or, it may have executed but the results have not yet been refreshed. Press F5 to refresh the list.

    If you find more objects listed than you expected, one object can call other objects, so there may be more items listed than those that users explicitly called.

  5. To view in-depth profiling results for a specific object, double-click the object on the Profiling Results tab.

Résultat

The right pane details are replaced with in-depth profiling information for the object.