Creating a diagnostic tracing session (SQL)

You can start a tracing session by executing the ATTACH TRACING statement in Interactive SQL.

Prerequisites

DBA or PROFILE authority.

Context and remarks

Note

Starting a tracing session is also referred to as attaching tracing. Likewise, stopping a tracing session is referred to as detaching tracing. The SQL statements for starting and stopping tracing are, respectively, ATTACH TRACING and DETACH TRACING.

 Create a diagnostic tracing session

  1. Connect to the database.

  2. Use the sa_set_tracing_level system procedure to set the tracing levels.

  3. Start tracing by executing an ATTACH TRACING statement.

  4. Stop tracing by executing a DETACH TRACING statement.

Results

The tracing session is created and completed.

Next

The diagnostic tracing data can be viewed in Application Profiling mode in Sybase Central.

Example

This example shows how to start diagnostic tracing on the current database, store the tracing data in a separate database, and set a two hour limit on the amount of data to store. This example is all on one line: 

ATTACH TRACING TO 
'UID=DBA;PWD=sql;Server=server47;DBN=tracing;Host=myhost' LIMIT HISTORY 2 HOURS;

This example shows how to start diagnostic tracing on the current database, store the tracing data in the local database, and set a two megabyte limit on the amount of data to store: 

ATTACH TRACING TO LOCAL DATABASE LIMIT SIZE 2 MB;

This example shows how to stop diagnostic tracing and save the diagnostic data that was captured during the tracing session:

DETACH TRACING WITH SAVE;

This example shows how to stop diagnostic tracing and not save the diagnostic data.

DETACH TRACING WITHOUT SAVE;

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1