Planning

The system administrator performs the analysis described in steps 1 and 2 in “Successfully distributing resources” and decides on this hierarchy plan:

Table 4-1 summarizes the analysis and specifies the execution class to be assigned by the system administrator. The tuning granularity gets finer as you descend the table. Applications have the greatest granularity, or the largest scope. The stored procedure has the finest granularity, or the narrowest scope.

Table 4-4: Example analysis of an Adaptive Server environment

Identifier

Interactions and comments

Execution class

OLTP

  • Same tables as isql

  • Highly critical

EC1

isql

  • Same tables as OLTP

  • Low priority

EC3

L1

  • No priority assignment

None

sa

  • Highly critical

EC1

L2

  • Not critical

EC3

sp_xyz

  • Avoid “hot spots”

EC1