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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Reference » Tables


Diagnostic tracing tables

Following are the main tables that are used for application profiling and diagnostic tracing. These tables are owned by the dbo user. For many of these tables, there exists a global shared temporary table with a similar name and schema. For example, the sa_diagnostic_blocking table has a global temporary table counterpart, sa_tmp_diagnostic_blocking table, which has the same schema. During a tracing session, diagnostic data is written to these temporary tables. Because temporary tables are not logged, they provide superior performance during a tracing session, where it is important to minimize the impact on the server.

 See also

sa_diagnostic_auxiliary_catalog table
sa_diagnostic_blocking table
sa_diagnostic_cachecontents table
sa_diagnostic_connection table
sa_diagnostic_cursor table
sa_diagnostic_deadlock table
sa_diagnostic_hostvariable table
sa_diagnostic_internalvariable table
sa_diagnostic_query table
sa_diagnostic_request table
sa_diagnostic_statement table
sa_diagnostic_statistics table
sa_diagnostic_tracing_level table