Learn Advanced Informix Performance Tuning
Folks, Art Kagel and I will be teaching another Advanced Informix Performance Tuning Class the week of July 18-21, 2016. You can attend the course online or in person at our office in Annandale, VA. Attend online using our Webex Training System and SSH to securely login to our training server for the course labs. This 4-day course focuses on techniques for optimizing an Informix Database. Labs will demonstrate more than 100% performance improvement. Each student will have a 4-core Linux server with Informix 12.10 and a large data set for benchmark exercises and labs. This 4-day course is for Informix database administrators and application developers who will be responsible for installing, managing, optimizing and tuning an Informix Database Server. The focus is on practical skills, procedures, and scripts to improve the performance of your database server. In addition to your new skills, the course will provide a toolkit of scripts and utilities to start monitoring and optimizing your Informix database server. The course is taught by Lester Knutsen and Art Kagel, Principal Database Consultants. This course has been updated for Informix 12. Course Outline: New Features in Informix 12 and Informix 11 New ONCONFIG Parameters New Performance Tuning Guidelines Introduction to Performance Tuning and Optimizing A Checklist for Troubling Shooting Informix Performance Optimizing the Informix Server Configuration Tuning OLTP Systems Tuning Data Warehouse Systems Tuning Data Loads Managing and Tuning Client Server Database Access Tuning Dbspaces, Chunks, and Disk Layouts Enable Large Chunks Informix Server Monitoring Utilities Using the Onstat Utility for Performance Tuning Using the Oncheck Utility for Performance Tuning Managing Logs Tuning the Physical Log Tuning the Logical Log Sizing Tables and Fragmentation Tuning Table Fragmentation Improve Performance Using Optimized Informix Data Types Improve Performance Through Sizing Tables and Extent Planning Using and Tuning Indexes Tuning Index Builds Managing and Tuning Update Statistics Managing and Tuning Parallel Data Query Optimization and Tuning SQL Statements SET EXPLAIN Optimization and Tuning SQL Statements Tuning Sorts Performance Optimization of Unix for Databases Informix Server Monitoring Using the Sysmaster Database Course Labs: The course includes 12 hands-on labs with exercises for students to implement and practice the concepts taught in this class. The labs are taught as a performance tuning benchmark where students work on improving the performance of a base system. For more information please email lester@advancedatatools.com or visit our web site at: http://www.advancedatatools.com/Training/InformixTraining.html Regards - Lester -- ______________________________________________________________________ Lester Knutsen lester@advancedatatools.com Advanced DataTools Corporation Voice: 703-256-0267 x102 Visit our Web page: http://www.advancedatatools.com ______________________________________________________________________