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
Friday, February 27, 2009
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment