How do you capture the cost of SQL statements and activity on your database server. We will take a look at SQL Trace, and the Sysmaster tables that enable you to save and analyze the costs of your SQL.
Lester again presented new scripts to monitor and tune your Informix Database server using the Sysmaster and Sysadmin Databases. This is major update to his most popular talk at the International Informix User Group (IIUG) conferences over many years - "Exploring the Sysmaster Database".
Lester Knutsen and Mike Walker will present a series of tools to monitor and tune your Informix Database Server.
*Using SQL Trace to monitor user sessions
*Tips for Remote DBA monitoring
* Building a Monitoring Dashboard with Yellowfin BI