||New Sysmaster Queries to Monitor and Tune - What I have learned in the last year|
||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.|
|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.