services-hub-hero

Progress OpenEdge Database Performance Tuning

On-Demand Training

services-education-illustration

Course Details

This course is available via a subscription to the OpenEdge 11 Administrator learning path at $900 USD per user per year. See the How to Subscribe instructions below.

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 this course, you will learn how to design, configure, monitor, and tune an OpenEdge database for optimal performance. First, you will be introduced to OpenEdge database performance tuning. Next, you will learn how to design and configure a database for best performance. Then, you will 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, and network communication. Finally, you will learn about performance guidelines for advanced database options such as OpenEdge Replication, OpenEdge Transparent Data Encryption, OpenEdge Multi-tenancy, and OpenEdge Table Partitioning.

This course is also available as Instructor-Led Training.

Audience

This course is designed for database administrators who need to tune Progress OpenEdge databases.

Duration

Equivalent to 18 hours of instructor-led training

Product Version

Progress OpenEdge 11.6

What Will You Learn

After completing 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.
  • List performance guidelines for advanced database options

Training Prerequisites

Students should already be able to:

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

How to Subscribe

how to subscribe step1
Step 1

Visit the Progress Education Community (PEC) and log in with your Progress ID. If you do not have a Progress ID, follow the instructions to register for one.

how to subscribe step2
Step 2

Find your content (Learning Path, course, or exam) on the eCommerce page and purchase via PayPal or credit card. Note: Enter the First Name, Last Name, and Email associated with your Progress ID on the Course Checkout page.

how to subscribe step3
Step 3

When the transaction is complete, click the PEC logo to return to the home dashboard and access your purchased content.

Services prefooter banner

Interested in the Class?

Stay up to date with technology trends and get the most out of your Progress technology investment.