As analytics continue to drive business efficiencies, data volumes are increasing at break-neck speed. Given this volume-intensive environment, it’s not uncommon to find applications that are missing the mark (i.e. exceeding their processing windows, missing SLA’s, or just plain disappointing the business).

onDemand provides its experience in monitoring existing data warehouse applications and ensuring their optimal performance and business value:

Upon the diagnosis of performance issues, onDemand works with your team to help optimize the execution of your applications. Some common causes of performance degradation include: 

• Non-use or limited use of data parallelism when data volumes are high
• Use of multiple application steps where one would suffice
• Inappropriate use of common design techniques
• Over-sorting
• Carrying data through the application past its usage point (In other words: not dropping data after it is no longer required)
• Starting up too many processes at once (thrashing)
• Poorly optimized database interactions (inappropriate SQL / Lack of indexes, etc.)