Solution performance assessment
The data domain has matured in recent years with the emergence of high performance big data and real time analytics technologies. How do you maximise the performance of your existing assets whilst defining, measuring and managing transition to target state?
Performance assessment is often treated as an unmeasured, qualitative activity or deferred to later stages in the project delivery lifecycle.
Without objective, frequent and quantitative measurement data, solutions often gradually slide from acceptable to unacceptable performance with no obvious underlying cause.
Our performance SMEs have a comprehensive understanding of existing technologies as well as an up-to-date market view of emerging alternatives.
Coupled with tools and resources to accelerate the process of measuring solution performance against a range of data set characteristics, our consultants are able to quickly identify solution limitations and problem areas.
An existing client of ours has extensive investment in standalone Oracle implementations. A reporting application was experiencing rapid growth in both data volumes and the end user community so they were looking to define a minimally disruptive performance roadmap.
After a brief solution assessment, we identified a step change opportunity through exploiting Oracle 12c's Database In-Memory (columnar storage) feature. By leveraging a three way partnership with the client's internal centralised performance team and Oracle UK, we designed a set of tests to objectively measure key performance statistics across a range of representative parallel workloads. Test execution was then carried out utilising our Performance Accelerator load simulator and results collated and interpreted by our performance consultant.
The resulting performance report was able to identify key areas of gain (in some cases up to 700 times faster) as well as recommend refactoring opportunities to better exploit the performance of both the standard Oracle 12c solution design and the proposed Database In-Memory uplift.
More importantly, opportunities were identified to migrate and consolidate functional capabilities into the reporting application from other software components to maximise the investment in this technology. To demonstrate this, a thorough cost-benefit analysis was performed to evaluate the increased licensing costs against savings in data storage and architecture simplification.