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

 

Enabling procedure profiling

Enabling procedure profiling allows the database server to gather profiling information until you disable profiling or until the database server is shut down.

Prerequisites

You must be running the network server (dbsrv), not the personal server (dbeng).

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

Context and remarks

Note

All profiling information is deleted when the database server is shut down. To export profiling information, use the sa_procedure_profile system procedure.

You cannot use SQL statements to query profiling information retained by the database server. Profiling information is kept in in-memory database server data structures.

 Task

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

  2. In the left pane, select the database.

  3. Click Mode » Application Profiling.

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

  4. 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.

Results

Procedure profiling is enabled and the database server collects procedure profiling information.

 See also
Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0