You can use the Application Profiling Wizard in Sybase Central to perform a diagnostic tracing session for profiling applications. The wizard gathers data on how your applications are interacting with the database and provides you access to the data and with indexing recommendations, if relevant.
You must have the DIAGNOSTICS system role, and the MANAGE PROFILING, SERVER OPERATOR, and SELECT ANY TABLE system privileges.
Context and remarks
The Application Profiling Wizard cannot be used to create a tracing session for a database running on Windows Mobile. You must use the Database Tracing Wizard.
When you use the Application Profiling Wizard in Sybase Central, the wizard automatically creates a tracing database with the same name you specify in the wizard for the analysis file.
For more information about the indexing recommendations returned from the Application Profiling Wizard, see Index Consultant recommendations.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Click Mode » Application Profiling.
If the Application Profiling Wizard does not appear, click Application Profiling » Open Application Profiling Wizard.
Follow the instructions in the Application Profiling Wizard.
creates a local database to hold diagnostic tracing information
starts the network server
starts a tracing session
prompts you to run the application you would like to profile
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|