Conference Schedule – Subject to Change


Presentation Information

Presentation Title:   Making System Monitoring better.
Primary Speaker:   Benjamin Thompson
Bio:   Benjamin is the Principal DBA for Sky Betting and Gaming, an online 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 as occasionally 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 wider community. Benjamin's primary work responsibility is oversight of his company's production databases which have 24/7 uptime requirements and high 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.
or Panelists: