SQL Performance Audits and Reviews - Any platform, any number of queries and programs, individual or group setting.
DB2 Performance Audits and Reviews - Any platform, number of subsystems or instances.
DB2 Health Checks - Any platform, number of subsystems or instances.
SMLI will analyze the system to improve overall throughput and CPU consumption of the system. SMLI believes that there is usually an enormous CPU, I/O cost reduction potential in doing a detail analysis of any application. SMLI will analyze programs for their I/O and CPU characteristics in terms of their database and subsystem usage and interfacing between the main platform and other environments.
This engagement will produce detailed documentation discussing the system analysis findings along with detailed recommendations, best practices and strategy for improving the overall performance of the system.
