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.