Conference Schedule

   

Presentation Information

Presentation Title:   New Sysmaster Queries to Monitor and Tune - What I have learned in the last year
Primary Speaker:   Lester Knutsen
Bio:   Lester Knutsen has been developing database applications with Informix databases since 1983. He is president of Advanced DataTools, an IBM Informix Consulting, Training, Support and Tools Partner specializing in data warehouse development, database design, performance tuning, and Informix training and support. Currently, Lester specializes in developing very fast web-enabled data warehouse systems. He provides training and consulting in database design and performance tuning, and is widely known in the Informix community for his extensive experience and teaching skill. Lester is founder and past president of the Washington D.C. Area Informix Users Group, and is one of the five founding members of the International Informix Users Group. Lester is also a member of the IBM Gold Consultant program and in October 2008 was awarded one of the Inaugural IBM Champion awards by IBM.
Presentation
Abstract:
  
This is the latest update to my talk on Exploring the Sysmaster database. We will present new scripts to monitor and tune your Informix Server. Examples include how to tell what is the most expensive query running on your server now, what page size is best for your tables, what indexes are used and not used, how is memory used on your server, and much more.... These scripts will help you identify the performance bottlenecks on your Informix Server.
Co-Speakers
or Panelists:
  
None