Replay Informix TechTalk: Informix Sysmaster Database Queries for monitoring and performance tuning by Lester Knutsen From: Thursday, February 2, 2023, 2:00 pm EST Download my latest Sysmaster Scripts for this presentation – Sysmaster2023.zip YouTube Replays: https://youtu.be/C9zk8FmuUFQ Download Slides: Informix-SYSMASTER-2023-LesterKnutsen.pdf Description: Lester Knutsen will present his favorite Informix Sysmaster Scripts for monitoring and performance tuning tips. This […]
Tag Archives: Performance Tuning
Tag for posts that refer to database performance tuning.
IIUG World 2021
Advanced DataTools is proud to be a sponsor for IIUG World 2021 for the Informix User Community. IIUG World 2021 information and registration – http://world.iiug.org Informix 14.10 Training – Our training is an Instructor-led virtual online class. – Attend online via interactive Webex – Perform hands-on labs on your class server – Q&A and collaborative […]
Running Informix in a Monster Virtual Machine
Running Informix in a Monster Virtual Machine Lester Knutsen presented at the IIUG Informix Conference April 23-27, 2018 in Raleigh, NC.
A monster virtual machine is a VM with lots of memory, CPUs and disks. I have been dealing with many Informix database servers running in a virtual environment and will share some of the problems and solutions for Informix to work well in VM. We will talk about everything from a VM on my laptop to a VM with more than 256 GB of memory and more than 96 Virtual CPUs.
Fastest Informix DBA Contest VI – September 2013
Fastest Informix DBA Contest VI winners – September 2013
Fastest Informix DBA VI – 2013 – How Did They Do It?
Article on the Fastest Informix DBA 2013 Contest and how the winners succeeded.
Fastest Informix DBA Contest V – April 2012
Fastest Informix DBA Contest V Winners – April 2012
Fastest Informix DBA Contest IV – May 2011
Fastest Informix DBA Contest IV Winners – May 2011
Fastest Informix DBA Contest III – April 2010
Fastest Informix DBA Contest 3 Winners – April 2010
Fastest Informix DBA Contest III – How did they do it?
Last year at the 2010 IIUG Informix User Conference in Kansas City we hosted a new “Fastest Informix DBA Contest”. This contest was different from the earlier ones, and focused on “How many transactions per minute” could the contestants tune an Informix database to achieve. The previous contests had focused on improving batch processing performance […]
Fastest Informix DBA Contest II – Fall 2009
Fastest Informix DBA Contest 2 Winners – Fall 2009
Fastest Informix DBA Contest I – April 2009
Fastest Informix DBA Contest 1 Winners – April 2009
Unix Tools and Scripts to Monitor and Tune Your Informix IDS Server
Presentation on Unix Tools and Scripts to Monitor and Tune Your Informix IDS Server – given at the 2005 IBM Data Management User Conference.
Exploring the Sysmaster Database
This post is the original article I wrote on Exploring the Sysmaster Database and has been reprinted in the Informix TechNotes, the Informix DBA Survival Guide, Second Edition by Joe Lumbley, the Informix Handbook by Ron Flannery, and many other places. Open the orginal PDF of this article: https://www.advancedatatools.com/Downloads/Symaster_articule.pdf When you list all the […]