Diagnostic tracing data provides a record of all activities that took place on the database server and that correspond to the diagnostic tracing levels and the tracing session settings. When reviewing the data, you must consider the settings that were in place. For example, the absence of a statement that you expected to see in a tracing session might indicate that the statement never ran, but it might also indicate that the statement was not expensive enough to fulfill a condition that only expensive statements be traced.
There are many reasons why you may want to examine in detail what activities the database server is performing. These include troubleshooting performance problems, estimating resource usage to plan for future workloads, and debugging application logic.
Application Profiling does not capture an event, but captures long-running statements within the event. To capture an event, embed the event code within a procedure and call the procedure from the event. Before running the procedure, turn on tracing with a custom level that specifies low detail with no conditions on statement capture. When the tracing session is finished, turn off Application Profiling.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|