In addition to providing Informix product support and maintenance, Oninit ®provides advanced remote monitoring services for Informix. These are considered vital for businesses that have limited Informix resources, but are using an Informix-based application to support their business. In order to provide these support services, we use a suite of database server monitoring products from AGS, Nagios and in-house scripts. These tools allow Oninit ®to evaluate and resolve problems on the customer system remotely which reduces the time taken to resolve issues.
Changes in the memory usage can often be overlooked and sudden changes in the usage pattern are typically an indication of a system alteration, or maybe an application problem.
By monitoring of physical and logical log usage it is possible to identify changes in the overall system load. This change could be an indication that transactions are misbehaving, poor SQL. etc.
Basic Informix performance monitoring and tuning
Physical disk utilization and placement of logical entities have a direct bearing on the overall system performance but over time the original relationships and assumptions may no longer be valid. In the ideal world the I/O for all the disks should be equal.
Informix allocates disk space for tables in extents. While there is a maximum number of extents that can be allocated to a table, the limit is unlikely to reached in the later engines. But excessive extents are an indication of a badly designed table. By monitoring the number of extents it is possible to identify tables that are growing outside the assumed business projection.
By monitoring the growth of tables and the extent utilization it is possible to determine when more space must be allocated and ensure that the space is created in a timely manner.
Correct fragmentation policies will dramatically reduce the system I/O and will speed up SQL performance.
These will be developed as the contract progresses and are designed to monitor Customer specific issues and concerns
When Oninit ® remote monitoring service is implemented a number of thresholds are identified that allow the system to alert our support desk to conditions that may need further immediate attention. These thresholds will be tailored to the Customer so that false alarms are not raised. In addition the system is reviewed weekly by a consultant who will identify key areas that may need further administrator attention. Before any work is performed on a live system, the work is documented and approved.
Access to the required systems will be determined and detailed separately, but Oninit ® will comply with any security requirements specified by Customer. Any expense associated with these requirements will be charged at cost to Customer.
Existing customers can see their table and index statistics live.
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.