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 a diagnostic tracing session (Sybase Central)

In Sybase Central, you can create a diagnostic tracing session to gather tracing data from your database.


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

When you start a diagnostic tracing session, you also configure the type of tracing you want to perform, and specify where you want the tracing data to be stored. Your tracing session continues until you explicitly request that it stops.

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

  2. Right-click the database and click Tracing.

  3. Click Next.

  4. On the Tracing Detail Level page, select the level of tracing.

  5. On the Edit Tracing Levels page, customize the diagnostic tracing settings.

  6. On the Create External Database page:

    • Click Create A New Tracing Database.

    • Select a location to save the database.

    • Complete the User Name and Password fields.

    • Click Start Database On The Current Server.

    • Click Create Database.

  7. On the Start Tracing page:

    • Click Save Tracing Data In An External Database.

    • Complete the User Name and Password fields. Specify the user name and password used to connect to the production database.

    • In the Other Connection Parameters field, type the database server and database name in the form of a partial connection string. For example, Server=Server47;DBN=TracingDB


      Only DBN, DBF, Server, DBKEY, HOST, and LINKS (CommLinks) are supported in the connection string for an external database.

    • In the Do You Want To Limit The Volume Of Trace Data That Is Stored list, select an option.

  8. Click Finish.

  9. When you are done gathering diagnostic tracing data, right-click the database and click Tracing » Stop Tracing With Save.


The diagnostic tracing session has started and completed and the data is saved.

 See also