Hi Everyone;

We are working on tuning a compact framework mobile application which
uses the Sybase iAnywhere 9.0 as the database. Performance of the
stored procedures have been really bad. But we are at our wits end
trying to find out the Stored procedures which are causing the biggest
harm.

I have the following questions:

1. Do we have a command which can start the profiler on the iAnywhere
database.

2. Can we direct Sybase iAnywhere 9.0 to write the trace output to a
text file(something like oracle), which can be later used for further analysis as to which
stored procedure are the ones which are taking time.

Your suggestions and comments are highly welcome.

Kind Regards;

Ajit Goel