Conference Schedule

   

Presentation Information

Presentation Title:   Highly Successful Performance Tuning of an Informix Database
Primary Speaker:   Tom Lehr
Bio:   Tom started his IT career as an Analyst at Werner Enterprises in 1998. After a few years, he switched to DBA work, starting with Access and SQL Server, and then moving into the Informix world soon after that.
Presentation
Abstract:
  
In January 2014, our production Informix database server
was consistently running at 75-80 percent CPU utilization
and the upcoming version of a mission critical
application had an unknown performance issue that was
pegging the CPU at 100% in the test/QA Informix
environment. These issues were the catalyst for
developing metrics to help identify and resolve
performance problems. A structured monitoring process was
established; over the course of the year, tuning efforts
identified 80+ problems and the average CPU utilization
was reduced to less than 30 percent. A number of helpful
tools were developed which greatly assisted in the tuning
effort. These tools will be shared with attendees of this
session.
Co-Speakers
or Panelists:
  
Brad Price