The downloads for the UKOUG Breakthrough 2022 talks are online here: „The Price We Pay – Performance and HA with Data Guard“ by Oracle ACE Director Martin Klier and and its „Making Of“ by Oracle Ace Axel vom Stein.

The Price We Pay – Performance and HA with Data Guard

Making database systems highly available is somewhat of a challenge. In the end, a whole chain of middle courses emerges, in which the interests of the end customer must be weighed conscientiously: The manufacturer makes compromises in order to provide the required functions. The planner makes compromises in order to obtain an affordable concept. The implementation makes compromises to make the system operable. And the operation makes compromises in order to survive with it in everyday life.

What does this area of tension look like in concrete terms? Complexity, costs, performance – Oracle ACE Director Martin Klier would like to shed light on these three fields in detail in his presentation, which was developed in close cooperation with Axel vom Stein. The focus will be on the problem area of system performance when using Data Guard: Which disadvantages do I buy by which HA features? How can I orient myself in this labyrinth of compromises with facts?

Making of: The Price We Pay – Performance and HA with Data Guard

Does high availability with Data Guard have a negative impact on the expected performance? Are the tensions between these two important principles of a stable environment important or negligible?

With a corresponding setup, HA expert Axel vom Stein, in cooperation with Martin Klier, got to the bottom of these questions using common performance tools and provides corresponding answers.

This presentation is not so much about the results, but about the way we got to these results. An introduction to Swingbench & ORION as well as preliminary considerations including the necessary evil of using a well-known spreadsheet tool will be included. Of course, everything is true to the motto: Don’t trust any statistics you haven’t faked yourself!

This is the „Making Of“ to Martin Klier’s presentation „The Price We Pay – Performance and HA with Data Guard“ about necessary trade-offs between availability and system performance in the database environment.