The following is a list of diagnostic tracing levels specified in the Database Tracing Wizard. For a description of the various diagnostic tracing types, see Diagnostic tracing types.
Estimated impacts to performance reflect the assumption that tracing data is sent to a tracing database on another database server (recommended).
Level 0 This level keeps the tracing session running, but does not send any tracing data to the tracing tables.
Level 1 Performance counters and a sampling of executed statements (once every five seconds) are gathered. For this level, the diagnostic tracing types include:
volatile_statistics, with sampling every 1 second
non_volatile_statistics, with sampling every 60 seconds
This level has a negligible impact on performance.
Level 2 This level gathers performance counters, a sampling of executed plans (once every five seconds), and records all executed statements. For this level, the diagnostic tracing types include:
volatile_statistics, with sampling every 1 second
non_volatile_statistics, with sampling every 60 seconds
statements
plans, sampling every 5 seconds
This level has a medium impact on performance—up to, but not more than, a 20% overhead.
Level 3 This level records the same details as Level 2 but with more frequent plan samples (once every 2 seconds) and detailed blocking and deadlock information. For this level, the diagnostic tracing types include:
volatile_statistics, with sampling every 1 second
non_volatile_statistics, with sampling every 60 seconds
statements
blocking
deadlock
statements_with_variables
plans, with sampling every 2 seconds
This level has the greatest impact on performance—greater than 20% overhead.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |