Video Series: Monitoring Part 5 – Very Active Sessions
In this video Tom describes how you can monitor very active sessions in your OpenEdge environment.
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.
Understanding UNIX Performance Metrics – Part One
In the techie world, few things are as misunderstood as UNIX performance metrics. Grab a cup of coffee, sit down, and join me as I go over a few things.
Metrics shmetrics…what metrics?
There are many. Let’s start with a few CPU-related metrics, then we’ll tackle memory, disk, kernel, network and more in later blog posts.
ProTop Newsletter August 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.
Secrets of Database Startup Parameters – Part One of Two
Many are the secret societies in the human race: the Knights Templar, The Masons, The Department of Motor Vehicles…all carry a rich history of secrets and rituals both mysterious and inscrutable. One of the most secretive of such groups is that of the OpenEdge Database Administrators. Follow us, and you too may join their ranks.
So many parameters – what do they mean? Which should I use? Which shouldn’t I use? What are the secret magic values?
Database Buffers (-B)
The DBA equivalent of buying flowers for your wife – more is better…to a point. You want it to be big enough to hold the “working set” of data: the orders, invoices, pick-lists, etc. that your business needs right now to function efficiently.
Video Series: Monitoring Part 4 – Transaction Scope
Poor transaction scope and BI growth: the evil twins conspiring to crash your database! Take our word for it…we know.
Sometimes it’s bad code, sometimes it’s bad luck, but either way, Tom shows you how to protect your business against the potentially disastrous effects of out-of-control transactions.
ProTop Newsletter July 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.
Video Series: Monitoring Part 3 – Storage Areas
Are you using fixed length extents in your OpenEdge database? What happens if they fill? Will anybody notice?
SuperGeek Video Series: the -hash Parameter
The -hash parameter is one of those little-known, often misunderstood parameters that can cause you a LOT of pain if set incorrectly. Trust us, we’ve seen it kill performance on numerous occasions!
Check out the video below and JC’s blog post “The Smoking Gun” (2021-07-05) where he talks about a real-world production environment where they just couldn’t figure out why performance was sooooo bad!
ProTop Newsletter June 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.
User Died, DB Crashed, Business MAD!
Anyone who has been around the OpenEdge world for a while has had to face the dreaded “User died holding shared memory latch. ABNORMAL SHUTDOWN” crash. While this sometimes happens as a result of a Progress OpenEdge bug, more often than not it’s a human error. Here are three key points to understand in order to minimize the chance of crashing your database when trying to terminate a shared memory client.