Our performance tuning is a scientific examination of your database server to identify bottlenecks and provide recommendations on how to get the best results from your system. We begin by setting up scripts on your system to monitor and collect statistics from your server, the operating system, CPU, memory, and disk utilization. This will provide a complete Informix health check of your server.
We can also collect data on user sessions and the most resource-expensive SQL queries. After the data collection and analysis period, we make specific short- and long-term recommendations and work with you to establish a plan for improvements. We teach your staff our process, so they can continue to monitor your systems.
OPTION 1 - Premier Informix Performance Review and Tune-Up (Onsite or Remote)
A comprehensive Informix Performance Tune-Up and Health Check with at least one month of data collection, followed by a one-week consultation (onsite or remote via WebEx). The consultation includes an in-depth review of your server metrics to identify problems and provide recommendations.
- Remote collection of monitoring data to identify performance bottlenecks
- Staff training in the use of performance-monitoring scripts and overall database performance tuning
- Report on database server stats identifying any bottlenecks and problems including:
- CPU utilization of your server
- Network bandwidth and activity
- Disk layout and throughput
- SQL activity and costs
- Memory usage and optimization
- Detailed report with recommendations to improve the performance of the Informix database server
Option 2 - Standard Remote Informix Performance Review and Tune-Up
A two-session Remote Informix Performance Review/Health Check via WebEx. This service starts with a half-day WebEx session to collect data and review your configuration with your team. The data is then run through our performance analysis process. A second WebEx session is conducted with your staff to review the findings and provide recommendations.
Option 3 - Basic Remote Informix Performance Review
This service is a four-hour WebEx session to review your Informix Server setup, run a limited set of data collection scripts, and analyze the results. Recommendations are provided based on the data reviewed.