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 Usage » Monitoring and improving database performance » Improving database performance


Application profiling

Application profiling generates data that you can use to understand how applications interact with the database and to identify and eliminate performance problems. Two methods are available for generating profiling information; an automated method, using the Application Profiling Wizard, or using the tools and features found in Application Profiling mode of Sybase Central.

The Application Profiling Wizard is not supported on Windows Mobile; however, the Database Tracing Wizard is. You cannot automatically create a tracing database from a Windows Mobile device, and you cannot trace to the local database on a Windows Mobile device. You must trace from the Windows Mobile device to a copy of the Windows Mobile database running on a database server on a desktop computer.

  • Automated application profiling   Use the Application Profiling Wizard in Sybase Central to identify common performance problems. The wizard allows you to define the types of activities to profile and provides recommendations for improving database performance when it is complete. The Index Consultant has also been integrated into the Application Profiling Wizard and uses the data to recommend index improvements.

    An automated approach is ideal for environments with few database connections, or where sophisticated profiling is not required.

  • Advanced application profiling using diagnostic tracing   Use the Database Tracing Wizard to customize the data returned during a tracing session and where it is stored. You can also use the command line to return and store customized tracing data. You can control the activities profiled, and target specific issues. For example, you can target specific statements executed by the database server, query plans used, deadlocks, connections that block each other, and performance statistics.

    An advanced approach is recommended for environments in which the database has a high workload, or where sophisticated profiling is required to diagnose a problem. By customizing the tracing session, you can reduce the tracing scope to specific activities, and you can direct tracing data to a remotely located database. Both of these actions reduce the workload on the database being profiled.

    See Advanced application profiling using diagnostic tracing.

Application Profiling Wizard
Procedure profiling in Application Profiling mode
Enable procedure profiling
Reset procedure profiling
Disable procedure profiling
Analyze procedure profiling results