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.
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
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |