Video Series: Monitoring Part 2 – VSTs Alone Are Not Enough
There’s a lot of data available to you via the OpenEdge database VSTs, but there’s more than just the VSTs.
Posts by:
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.
There’s a lot of data available to you via the OpenEdge database VSTs, but there’s more than just the VSTs.
This post is part of the “New DBA Series.” Check blog.wss.com/for more posts in the series and other interesting DBA blog posts.
Here’s the first video in our Monitoring Series, aptly named “Why Monitor?”
Okay, so it’s not a number or a statistic, but it is certainly the most critical question. Along with this, who do the users call first? Is it you or somebody else? Know who’s going to get the call, and be sure they can always answer that question!
Believe it or not, we use a whole bunch of tools in addition to ProTop when analyzing performance issues. This video series will highlight a few of them, starting with the original and always timeless promon.
Data protection is comprised of two equally important components: backups and after-image archives. Almost everyone understands backups: if there’s a problem, they get you 95% of your data back, up until the time of the last backup. After-image archives get you down that last mile, containing the detailed changes that were applied to your database. Think of them as a recording that you can play back (we call this “rolling forward”) on top of your restored DB. All the recorded changes are applied to the restored database in the same way as they were done the first time around.
There are a lot of metrics that “everyone knows” you should be paying attention to. But much like “common sense”, it sure would be nice if more people knew about these metrics and why you should pay attention to them!