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

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » Performance improvements, diagnostics, and monitoring » Application profiling tutorials

 

Tutorial: Baselining with procedure profiling

Use the Application Profiling Wizard to create a baseline that you can use for comparison purposes when improving performance.

Procedure profiling provides execution time measurements for procedures, user-defined functions, events, system triggers, and triggers. You can set your saved results as a baseline and make incremental changes to a procedure, running the procedure after each change you make. You can then compare the new results to the baseline, to see if your changes worked as intended.

 Privileges
 See also

Lesson 1: Creating a baseline procedure
Lesson 2: Running an updated procedure against the baseline procedure
Lesson 3: Comparing the procedure profiling results