Performance Optimization

During aggregation in SAP ASE, if you note a performance degradation, perform the following steps on the SAP ASE Server Management Console:

  1. To view the number of open databases in the SAP ASE Server, use the following command:

    sp_monitorconfig 'open'

    This command displays the number of open databases under the Number of Open Databases column.

  2. To increase the number of open databases, run the following command:

    sp_configure "number of open databases", x ;

    where x is the number of open databases that must be set.

  3. To view the number of auxiliary scan descriptors set, use the following command:

    sp_monitorconfig 'aux scan descriptors'

    This command displays the value of Num_free and Num_active columns. The sum of the values of Num_free and Num_active columns represents the number of auxiliary scan descriptors.

  4. To set the value of the auxiliary scan descriptors, use the following command:

    sp_configure "aux scan descriptors", x;

    where x is the number of the auxiliary scan descriptors that must be set.

    The number of auxiliary scan descriptors must be more than three times the number of open databases. If this is not set properly than lower of the two values (number of open databases or auxiliary scan descriptors/3) is used during aggregation and this may affect the aggregation performance.

    The maximum number of open databases during aggregation is limited to 100. If the number of open databases is greater than 100 with appropriate auxiliary scan descriptors than only 100 open databases would be considered.

  5. By default performance optimization is enabled. To use minimum permissions user must add the following entry key in the application debug page:

    <entry key="isMinimumPermissionUser" value="true"/>

    For performance optimization, it is required that the user has elevated roles.

    User having earlier set of permissions must add the following line in application debug page to use minimum permissions to complete aggregation successfully:

    <entry key="isMinimumPermissionUser" value="true"/>

    In case the following entry key is set to false, the Service account must have mon_role to complete the aggregation successfully:

    <entry key="isMinimumPermissionUser" value="false"/>