||Making System Monitoring better.|
||Benjamin is the Principal DBA for Sky Betting and Gaming, an
bookmaker and gaming company, having worked
previously for TSYS, a US credit card processor, and
Monitor Computer Systems, a provider of alarm
monitoring software to the Europe, the Middle East and
US. In all his roles he has been primarily working with
Informix. Along the way he also picked up a few skills
in other RDBMSs but Informix remains my favorite
to work with.
Benjamin's main regular contribution to the Informix
community is to write
blog posts covering topics of concern to a production
Informix DBA as well
contributing to the IIUG technical discussion groups.
You can find his writings under Informed Mix.
Locally in Yorkshire, he is a committee member of YoDB, a
local database user group, which doesn't focus on Informix
but has featured
some talks on IoT and Informix on single board computers of
interest to the
Benjamin's primary work responsibility is oversight of his
production databases which have 24/7 uptime requirements and
transaction throughput levels. This
tends to make the company well-known to EMEA support.|
|Does your system monitoring involve little more than tailing
the online log, obsessing over checkpoint durations plus
calculating a few abstract metrics around buffer pools?
Understand your system a lot better with some simple tools
and some more advanced ones.
I recall when I began my first role with DBA in the job
title, the DBA Manager asking me to create an Informix
monitor to integrate with HP Sitescope. What would I monitor
he asked? I thought of about ten things. With almost ten
years since then to ponder and the coming of the SQL System
Monitoring Interface (SMI), Iíve come up with a few more,
both suitable for ad-hoc use and automation through various
open-source tools (Nagios compatible systems, Graphite) plus
ways to very quickly find out what is wrong with your system
when troubleshooting. Iíll also focus on what I believe is
important and solutions to some issues you might see which
may improve the throughput and scalability of your system.