Friday, February 27, 2009

Query Performance Business Case

Query Performance Business Case

Goal
Predictable performance to Ad-Hoc Queries

Alternatives• HW Change: get more powerful HW, get additional HW, i.e. BI Accelerator, add memory, etc
• SW Change: change database, change DW software, Teradata, BI Accelerator, Neoview, Upgrade BI, etc
• Remodel: Single EDW Architecture, enhance Architecture, Modeling, Automated InfoCube modeling

Findings
Reported=by vendor; tested= real life ‘N’x= times faster

HW Change: can result in a max of 4x times reported improvement. BIA can result in tested 18-60x performance improvement. Add memory tested 3x to 5x improvement

SW Change: database change from oracle to DB2 reported a max of 18x but has other issues to consider; non SAP solutions can increase performance by 40x-60x but add integration costs; BI Accelerator tested at 18x-60x improvement; Upgrade could degrade performance but plan for 1x-2x improvement with functionality changes.

Remodel: Single EDW tested at 4x-8x in cross SBU reports; Enhance Architecture provided 2x to 5 x improvements; automated modeling findings 30x to 90x improvements

Collaboration: Automated InfoCube modeling and automated create InfoCube from DSO ++ in combination with BI Accelerator tested at 100x to 180x

No comments: