Posts by:
Paul Koufalis
Paul Koufalis is the President of White Star Software. He began his OpenEdge DBA career more than 25 years ago after completing a Computer Engineering Degree at McGill University. Today, he’s known for his pragmatic and ROI-centric approach when working with White Star’s global client base. When he’s not staring at his multiple immense computer screens (how much is too much?), you can probably find him speaking at a Progress event somewhere in the world or being roughed-up by his twin boys back home in Montreal.
How to Choose a Storage Area for a Table
Where should you put that new table and its associated indexes and LOBs? Let's figure it out together!
New DBA Series: Please Don't CRASH Your Database AGAIN!!
Read on for more soul crushing, database corrupting, career killing ways to CRASH your OpenEdge database!
Linux "Out of Memory Killer"
A Linux self-preservation mechanism, the OoMK terminates a process when memory is over-committed. Unsurprisingly, the OoMK kills the process consuming the most memory, which, most likely, is the database broker process.
A quick Google search will turn up numerous interesting articles on how to avoid this situation, including ways to tune "oom_adj". In practice, though, it is unlikely that your database will be spared and you are better off making sure that you have ample memory to handle the expected workload on your server.
Worst Practices – Part One
A catalog of wince-inducing practices to be avoided for the OpenEdge or, indeed any, database.
New DBA Series: Basics of Database Storage – Part One
Why is storage so important in a world of 99.9% buffer hits? I’m glad you asked!
ProTop Newsletter December 2021
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.
0-day exploit found in log4j2, impact for OpenEdge users
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.
Performance Series: Network Clients Part 3: Real World Examples
New DBA Series: More Ways to CRASH Your Database
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!
Understanding UNIX Performance Metrics – Part Two
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?