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

 

Lesson 3: Comparing the procedure profiling results

Compare the procedure profiling results to determine if the updated procedure improved on execution times.

Prerequisites

This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Baselining with procedure profiling.

This lesson assumes that you have completed all preceding lessons. See Lesson 1: Creating a baseline procedure.

 Task

  1. In Sybase Central, click Mode » Application Profiling.

    If the Application Profiling Wizard appears, click Cancel.

  2. In the left pane of Sybase Central, in Procedures & Functions, click the baseline procedure.

  3. In the right pane, click the Profiling Results tab.

  4. Click View » Refresh Folder.

    Two new columns, Execs. +/- and ms. +/-, appear.

    For each line in the procedure, the profiling results show the number of executions, the number of executions relative to the baseline procedure, the duration of execution, the duration of execution relative to the baseline procedure, and the percentage of total time the line took to execute.

    The Execs. +/- and ms. +/- columns result from comparing statistics in the profiling log file to the statistics captured during the most recent execution of the procedure. Specifically, they compare number of executions and duration of execution, respectively, for each line of code in the procedure.

    The ms. +/- column indicates whether you improved the execution time for lines of code in the procedure. Faster times are indicated by a minus sign and red font. Slower times are indicated by a plus sign, and green font.

    In this tutorial, the value in the ms. +/- column should be a plus sign along with an execution time in green font. The INSERT statement in the updated procedure has a slower time than the INSERT statement in the baseline procedure.

Results

You have completed the tutorial on baselining with procedure profiling.

Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0