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 » Diagnostic tracing

 

Creating an external tracing database (Sybase Central)

When you create a tracing session, you have the option of storing tracing data within the database being profiled. This is suitable for development environments where you are testing applications, or if there are few connections to the database.

Prerequisites

To start a tracing session, TCP/IP must be running on the database server(s) on which the tracing database and production database are running.

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

Context and remarks

Note

If your database typically handles 10 or more connections at any given time, it is recommended that you store tracing data in an external tracing database to reduce the impact on performance.

You can use the tracing database to store data for subsequent tracing sessions.

 Task

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

  2. Click Mode » Application Profiling.

    If the Application Profiling Wizard appears, click Cancel.

  3. In the left pane, right-click the database and click Tracing.

  4. On the Create External Database page in the Database Tracing Wizard, click Create a new tracing database and follow the instructions.

Results

An external database to store analysis data is created and a tracing connection is established.

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