This section provides information about using SQL Anywhere analysis tools to analyze and correct database performance.
SQL Anywhere provides several diagnostic tools for the detection of production database performance issues. Some of the tools rely on the diagnostic tracing infrastructure; a system of tables, files, and other components that capture and store diagnostic data. You can use diagnostic tracing data to perform diagnostic and monitoring tasks such as application profiling.
There are several methods for analyzing SQL Anywhere performance data including:
|Diagnostic tracing tools||
In the documentation, the terms application profiling and diagnostic tracing are used interchangeably. Diagnostic tracing is advanced application profiling.
You can use Sybase Central to connect to a version 9 database server. However, the layout of windows in Sybase Central reverts to the version 9 layout, which does not include Application Profiling mode. Refer to your version 9 documentation for information about locating and using the Index Consultant in Sybase Central.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|