Industrial Leader Safeguards Productivity with Optimized PPM System Performance

Managing over 10,000 projects with 5,000 users globally, this industrial leader relies heavily on Clarity Project and Portfolio Management (PPM) to ensure efficient project delivery and maintain productivity. However, persistent system slowdowns and discrepancies between database and application CPU performance hindered user productivity and delayed the processing of critical requests.

To resolve these issues, the company partnered with Rego Consulting to optimize the performance of their Clarity PPM system. Rego employed a multi-faceted approach:

• Job Scheduling Optimization: Conducted usage analytics to identify the best times for running specific jobs, ensuring data availability and system performance.
• Database Streamlining: Analyzed tables, indexes, and statistics, identifying fragmentation exceeding the recommended 30% threshold. Rego performed shrink operations to enhance performance.
• Database Cache Enhancement: Resolved an undersized database cache and addressed excessive database session durations causing session blocking and high physical I/O. Oracle jobs were rescheduled to run at night, unnecessary cron jobs were disabled, and long-running SQL indexes were rebuilt.

Rego Consulting’s expertise in tuning and optimizing Clarity PPM processes restored system stability and performance. Key outcomes include:

• Enhanced Productivity: Faster response times for 5,000 global users, improving overall productivity and user satisfaction.
• Efficient Project Delivery: A stable PPM environment ensures the timely execution of critical projects, supporting the company’s strategic objectives.
• Consistent System Performance: Streamlined processes and optimized infrastructure safeguard long-term system efficiency.

By partnering with Rego Consulting, this industrial leader has ensured that Clarity PPM continues to drive global operations effectively, enabling productivity and project delivery at scale.