The client is the leading, privately owned, nation-wide financial services group focusing on servicing mortgage banking in the US.

Client incurred significant costs as the result of a client/server payment collection application that became increasingly unstable as the number of users increased. Eventually the application crashed and Aaxis was engaged for production outage analysis and resolution. Client also required optimization of daily database and high-volume, month-end data processing activities.

Immediately upon being engaged Aaxis performed initial production outage analysis using its Absolute Resolution Methodology (ARM)™. Our team systematically performed a number of tasks:

• Made initial immediate recommendations that brought application back up within the first few hours
• Identified and resolved the lethal combination of database activities and events that caused the production outage
• Recommended changes to database replication jobs to prevent further production outages
• Identified and resolved application server configuration changes to eliminate unnecessary database activity
• Identified major performance bottleneck and recommended changes related to Storage Area Network (SAN)
• Identified and recommended changes to resolve memory-based performance bottleneck
• Identified missing indices and recommended new indices to improve SQL Server database performance

• Stabilized application to 99.9% uptime
• Reduced database CPU utilization by 50% from 95-100%
• Optimized daily data processing jobs reducing processing time by 1-2 hours
• Recommended changes in SAN hardware and configuration showing increased performance, reliability and redundancy
• Reduced database response time for application server from 15 seconds to nearly 0.
• Improved efficiency and reliability for high-volume month end data processing.