Use the lessons in this tutorial to learn how to 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 and run it after each change you make. This allows you to compare the new results to the baseline.
Lesson 1: Create a baseline procedure
Lesson 2: Run an updated procedure against the baseline procedure
Lesson 3: Compare the procedure profiling results
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |