To:
ids@iiug.org (Informix IDS Email List)
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 ______________________________________________________________________
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)