ProTop Newsletter September 2021
People often ask us: “what tasks should an OpenEdge DBA be performing? When? What should my daily, weekly, quarterly, etc. checklist have on it?”
In this video Tom describes how you can monitor very active sessions in your OpenEdge environment.
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.
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.
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.
… and, of course, it took longer than expected. Forty-five minutes to shut down (mostly to “deactivate” swap), and then, since the server hadn’t been rebooted for 2 years, the filesystems needed another 45 minutes for an fsck. Ok, that was painful, but at least we have a nice clean system to restart the db.
Are you using fixed length extents in your OpenEdge database? What happens if they fill? Will anybody notice?