Identifying Application Performance Requirements › Prioritizing Transactions

Prioritizing Transactions

Every data processing department must prioritize requests for transactions. For example, when a high-level executive requires access to vital organization information, the data processing department tries to provide this information immediately.

As the DBA, you are responsible for ensuring that critical transactions execute in an efficient manner. To optimize performance, you need to schedule data processing tasks according to specific organization priorities.

Assigning priorities to transactions

The following table shows how you might prioritize three typical transactions.

Establish a HIGH priority for transactions that are vital to the operations of the organization. For example, you might specify a HIGH priority for a transaction that services the information needs of upper-level managers in the organization.

Sample Transactions