Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Monitoring and Improving Performance

Introduction to monitoring and improving performance Next Page

Application profiling

Application profiling allows you to analyze tracing information to understand how applications interact with the database. With the data generated during a tracing session, you can also identify and eliminate performance problems. You can choose between two approaches for generating, and making use of, profiling information: an automated approach, using the Application Profiling wizard, or an advanced approach using the various tools and features found in Application Profiling mode of Sybase Central.

Application Profiling mode in Sybase Central allows you to explore the data gathered using either approach. For example, you can open a tracing session generated by the Database Tracing wizard to look at a statement and then see a list of all connections that blocked the statement. Or, you can browse the tracing session data gathered by the Application Profiling wizard to identify the most expensive statements and procedures, and gain insight into any other factors that are impacting the performance of your application.

Application Profiling wizard
Procedure profiling in Application Profiling mode
Index Consultant