
The OpenEdge DBA Files
Posts about:
Article


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.

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?

ProTop Newsletter November 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.
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.

New DBA Series: DBA Checklist – Part Two
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.

ProTop Newsletter October 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.
Today we’re going to take a deep dive into ProTop’s advanced alerting functionality. While the free version of ProTop provides a smorgasbord of data and insight into your OpenEdge environment, the commercial version adds features like alerting that help you sleep better at night.

Secrets of Database Startup Parameters – Part Two
In Part One, we discussed some of the more well known startup parameters. In today’s blog post, we’ll dig into parameters that are often used incorrectly or simply forgotten.

SyncIO Saves the Day
Every experienced IT person knows that bad things tend to happen on Fridays, and Friday evening is when we got alerted: major performance problems on the primary database server at one of our Enterprise clients.