Problem Statement: Problem Statement

The improvements are in several different categories…..

Physical Log

• Physical Log

• Logical Log

• Bufferpool

• CPUs

• These will follow similar rules guiding automatic tuning:

• How to detect when insufficient resources for each of the above resources are causing a performance impact
• How to increase the resource with minimal impact to the application
• How to control the increase of the resource so it adapts in a timely manner… not too much, not too little, just right

Purpose:

• Purpose:

• To help avoid performance loss associated with an undersized physical log caused by frequent server checkpoints which can block user transactions, located within an already constrained storage space with other objects therein, such as database and server objects.
•