Replay Informix TechTalk: Informix Sysmaster Database Queries for monitoring and performance tuning by Lester Knutsen From: Thursday, February 2, 2023, 2:00 pm ESTDownload 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 presentation introduces Informix performance from his Advanced Informix Performance Tuning Course. We will cover disk and chunk I/O, Log Turnover, Performance Ratios, Table and Index I/O, and identify the slowest SQL statements. Lester Knutsen is an IBM Informix Lifetime Champion with over 40 years of Informix experience.
These are my latest Sysmaster Scripts from my presentation at the Informix IIUG World Conference in 2019. Download presentation PDF: advancedatatools.com/…/Sysmaster_IIUG_Conf_2019_A12_LesterKnutse.pdf Download New Sysmaster 2019 Scripts (zip file): advancedatatools.com/…s/sysmaster2019.zip Download Past Sysmaster 2017 Scripts (zip file): advancedatatools.com/…s/sysmaster2017.zip
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 […]
First published in the Informix Tech Notes Magazine in 1999 When you list all of the databases on your Informix server, you will see one called “sysmaster”. This special database, which first appeared in Informix’s 6.x and 7.x servers, contains system monitoring interface (SMI) tables that can be used for monitoring your system. In […]