As a customer and technical lead I was worrying about the rapid storage growth with our organic growth. Every time whenever there is a need to add new storage I was first thinking about “how to control and stop this as a long time approach”. SAP has it’s own design of saving data at database level and no matter of database type that the customer use.
Now a days database vendors are coming with many options where we can save the database in compressed mode to save $s on storage. In this rapid growing technological world people says storage is cheaper than anything, yes it is. But it has it’s limitations as well where high storage always need high resources to run.
We pay big number of $s for our storage (may be customer specific, not for all), this might be becasue of low maintanance cost on other things (Yes we pay more for storage than other comparable ones).
SQL 2008 R2 – A new-gen technology with matured data store procedure delivered 86.5% of compression ratio on our each BW instance (It was a BIG saving for us)
Oracle 11gR2 – Advanced Compression Option, delivered 66.6% of compression ratio (3X) on our SAP R/3 (4.7) instance (Again a BIG saving)
It’s a matured data store procedure, saves data in a magical way by creating local symbol tables where duplicates get disappears. Really an innovative thinking 🙂
Resulting in high savings on storage/cost and performance improvement becuase of reduced database size.
Data store mechanism:
82% of compression on top 10 tables:
ACO implemetation saved storage of 7+ TB in our landscape (P,Q and DR systems), it reduced the total database size from 2.7TB to 0.9TB where overall performance improved by 10%.
Now a days most of the Oracle customers are investing on ACO for immediate ROI (ACO need seperate license if you have your database license from Oracle).
For more information:
1289494 – FAQ: Oracle compression
1109743-Use of Index Key Compression for Oracle Databases
1436352 – Oracle 11g Advanced Compression for SAP Systems
1431296 – LOB conversion and table compression with BRSPACE