Description

In today’s business environment, Progress OpenEdge databases are required to be running 24x7. They are also becoming larger and more complex. As an OpenEdge Database Administrator, you are responsible for making your OpenEdge databases perform at their peak. In the Progress OpenEdge Database Performance Tuning course, you learn how to design, configure, monitor, and tune an OpenEdge database for optimal performance. First, you are introduced to OpenEdge database performance tuning. Next, you learn how to design and configure a database for optimal performance. Then, you learn how to monitor and tune different aspects of a running database such as shared memory resources, before-image I/O, database I/O, after-image I/O, network communication, and indexes. Finally, you learn about performance guidelines for advanced database options such as OpenEdge Replication, OpenEdge Transparent Data Encryption, OpenEdge Multi-tenancy, and OpenEdge Table Partitioning.

Duration

This course is equivalent to 20 hours of learning. 

Audience

The audience for this course is an OpenEdge Database Administrator.

Product version

Progress OpenEdge 12.8

What you will learn

After taking this course, you should be able to:  

• Describe Progress OpenEdge database performance tuning.
• Design a database for performance.
• Configure a database for performance.
• Tune shared memory resources.
• Tune Before-Image I/O.
• Tune database I/O.
• Tune After-Image I/O.
• Tune network communication.
• Tune indexes.
• List performance guidelines for advanced database options.

Prerequisites 

Users should already be able to:

• Administer Progress OpenEdge databases.
• Use Progress OpenEdge ABL programs to perform administrative tasks (optional).