The OpenEdge DBA Files

Why is storage so important in a world of 99.9% buffer hits?  I’m glad you asked!

Welcome to our monthly ProTop newsletter, where you’ll find out what’s new, tips and tricks and other cool ways to use both the free and commercial versions of ProTop.

Visibility is one of the key themes when it comes to ProTop, and having the ability to see how the various objects in your database are growing is the focus of the storage statistics trends dashboard.

You may have heard that there is a critical security vulnerability in the “log4j” library that is used by many applications in the Java ecosystem and you might be wondering if this impacts your OpenEdge environment.

Nectar Daloglou‘s post on 99 Ways to Crash Your Database was so popular, we thought we’d bring you even MORE ways to ruin the upcoming holidays!

In today’s missive, we are going to talk about poor, misunderstood memory. How much is used? How much is free? How exactly do you define “used” and “free” memory? And the million dollar question: why should you care?

prefetchFactor, Message Buffer Size, MTU…how do all these parameters work together and how should you set them up in your OpenEdge environment?

Part 2 drives home the message with detailed benchmark results across physical and virtual machines and networks.

Welcome to our monthly ProTop newsletter, where you’ll find out what’s new, tips and tricks and other cool ways to use both the free and commercial versions of ProTop.

What is going on with the database!?! Lack of visibility is a complaint we often hear, and ProTop specifically exists to address this complaint. This month we are going to dive into one of the most valuable (and free!) features in ProTop RT: users of a table and users of an index.

In part one, we examined routine tasks scheduled for different times. In this post we’re going to look at special events and the checklists associated with them.

Before we deep dive into OpenEdge client/server performance, let’s make sure everyone is on the same page. This short presentation discusses client/server performance challenges and the tools we’ll use for our benchmarking tests in part 2: Benchmark Results.