HP Information Lifecycle Management ILM Database Growth Problems

HP Information Lifecycle Management (ILM) Database Growth: Problems & Solutions John Sosnowski – Account Executive Jeff Blackmon – Presales Engineer

Agenda u. The Data Explosion u. Effects of Database Explosion l. End User l. IT Operations l. Case Studies u. Solutions u. Q & A 3/17/2018 2 2

The Data Explosion u“Data Explosion”: 130, 000 Google Hits u“Information Life Cycle Management”: 1. 3 M Google Hits u Numerous analyst papers u Archiving vendors 3/17/2018 3 3

Data Explosion: Largest OLTP on Unix Databases u. Source: Winter Corporation; Top 10 Survey (www. wintercorp. com) u 2003: Max: 5. 4 TB, Average 2. 5 TB u 2005: Max: 16. 4 TB, Average 6. 8 TB 3/17/2018 4 4

Drivers for Data Explosion u. Increased regulatory retention requirements u. Increased business intelligence and trend analysis u. Increased detail with-in business transactions u. Consolidation of systems u. Underlying growth in business volume 3/17/2018 5 5

Data Explosion: Types of Data Business Applications ERP Systems Custom Apps (future) Databases (structured) 3/17/2018 Exchange Lotus Notes Enterprise Information Messaging (semi-structured) Enterprise Document Management Files (un-structured) 6 6

Data Explosion: Types of Data Business Applications ERP Systems Custom Apps (future) Databases (structured) 3/17/2018 Exchange Lotus Notes Enterprise Information Messaging (semi-structured) Enterprise Document Management Files (un-structured) 7 7

Data has a Lifecycle High Sales order booked Change order Partial shipments Complete shipment Access / SLA Requirements Customer invoices generated Sales order closed Customer inquiry Internal audit Retrieval Activity Low Time 3/17/2018 Regulatory data retention period ends Corporate data retention period 8 8

Inactive Data Large Sales order booked Change order Partial shipments Complete shipment Customer invoices generated Database Size Sales order closed Inactive Data Customer inquiry Internal audit Retrieval Activity Active Data Small Time 3/17/2018 9 9

Agenda u. The Data Explosion u. Effects of Database Explosion l. End User l. IT Operations l. Case Studies u. Solutions u. Q & A 3/17/2018 10 10

Effects of Database Growth u. End-User l. Declining application performance l. Decreased application availability l. Information overload u. Is your application presenting irrelevant information to end-user, causing extra work? 3/17/2018 11 11

Effects of Database Growth u. IT Operations l. Storage requirements l. Server requirements l. Backup and recovery windows l. Maintenance and upgrades windows l. Cloning operations l. Database and Application Tuning 3/17/2018 12 12

Case Studies u. Only studies that have been published: OAUG, Open. World, trade press u. All Oracle E-Business Suite u. All RIM for DB Live. Archive from HP/Outer. Bay u. In chronological order 3/17/2018 13 13

Applied Materials – Server Capacity u. Data growth of 4 GB per week u 14 clones of Production u. HP Live Archive implementation led to near zero growth u. Storage savings $1 MM/year u. Significant CPU utilization reductions extending server life by several years u. Runtime reductions on key reports by 50% Source: Out of Gas on the Biggest Box Made, Now What? Chei Yeh, Director Core Applications Applied Materials. OAUG Fall 2001 3/17/2018 14 14

Parsons Brinkerhoff - Upgrade u 10. 7 to 11 i upgrade of EBS u. Implemented Live Archive before upgrade u. Archive 35% of total DB u. Reduced Upgrade outage from 12 days to 6 days u. Allowed 3 clones to be supported on test server instead of 2 pre-archive u. User agreement for archiving was easy to achieve because of application access to archived data u. Source: “Worldwide Upgrade to Oracle 11 i: A Recipe for Success” OAUG Europe 2002 by Robert P. Dallesandro Parsons-Brinkerhoff 3/17/2018 15 15

Apollo Group - Upgrade u 10. 7 to 11 i upgrade window reduction u. Fixed window over 4 th July weekend u$50 K/day in productivity impact of additional outage window u. Archived 22% of the 190 GB database pre-archive u. Reduced outage window by 27% u. Avoided additional outage u. Lessons learned: Archive before starting upgrade project Source: “Oracle 11 i Data Upgrade Roadmap – A Lifecycle-Based Approach”, Grant Gasson, Director of Financial Systems Apollo Group, Inc. Fall 2002 OAUG 3/17/2018 16 16

Gevity: Storage Costs u. Reduced budget for storage – $1. 3 savings (2007– 2011) u. Avoid purchase of additional storage ($664, 474) for 2004 u. Dramatically reduce instances by approximately 2 TB l Saving total storage footprint of 12 TB at implementation u. Additional Benefits l Sustainable and predictable performance/storage costs l Allows high performance access to clients worldwide via new portal, while managing high performance reqs l Greatly reduced backup, recovery and clone times 3/17/2018 17 17

Agilent Technologies: Storage Costs u. Oracle EBS 11 i Single world-wide database u. Growth rate 1 TB+ per year u 20 + clones to support business initiatives u. Benefits l. Savings for Storage: 2. 5% of total 2005 IT budget l. HA, Backup & Recovery reduced spend and time l. Stable, predictable performance l. Free up resources for business initiatives Source: Agilent Case Study: Strategic Application Data Growth Management. By Naresh Shanker Sr. Director ERP Solutions, Agilent Technologies, Open. World SF 2004 3/17/2018 18 18

1300 Data Growth Impact Application Data 1200 1100 1000 900 800 700 600 Batch Run Time 500 Application Data (GB) Total Batch Run Time (Hrs/Month) Agilent: Tuning - Temporary 400 Phase I Tuning Source: Agilent Case Study: Strategic Application Data Growth Management. By Naresh Shanker Sr. Director ERP Solutions, Agilent Technologies, Open. World SF 2004 3/17/2018 19 19

Data Growth Impact Phase II Tuning Sustained Predictable Performance Archiving Source: Agilent Case Study: Strategic Application Data Growth Management. By Naresh Shanker Sr. Director ERP Solutions, Agilent Technologies, Open. World SF 2004 3/17/2018 Application Data (GB) Total Batch Run Time (Hrs/Month) Agilent: Archiving = Stability 20 20

Arvin. Meritor – Disaster Recovery u 60% reduction in database size u 90% reduction in DR window u 11 i upgrade outage reduction to 2 days u 30% performance improvement u. Lower database maintenance overhead Source: Automotive supplier curbs its runaway production database. Marcel Kuijs, director of IT at Arvin. Meritor's European IT data center. Storage Network World, July 2005. 3/17/2018 21 21

Case Study Themes u. Many drivers for archiving l. Performance l. Upgrade window u. Diverse set of secondary benefits l. Cost avoidance, storage, servers, tapes l. Free resources for Strategic Initiatives u. Benefits accrue to diverse parts of the organization l Data center l Business user l Application Support staff 3/17/2018 22 22

Agenda u. The Data Explosion u. Effects of Database Explosion l. End User l. IT Operations l. Case Studies u. Solutions u. Q & A 3/17/2018 23 23

Possible Solutions u. Data Deletion / Purging u. Add Capacity through Hardware Upgrades u. Decentralize or Do Not Consolidate u. Database Partitioning u. Database Archiving 3/17/2018 24 24

Solutions: Data Deletion/Purging u. Some data is not subject to regulatory requirements and has no ongoing business value u. Candidates: l Concurrent request data l MRP runs, Workflows, etc. l Temporary and Interface Tables Some Challenges! Ø Ø Ø Introduces risk and exposure to meet legal and compliance requirements No recourse, once the data is gone it is gone forever No validation for full data integrate 3/17/2018 25 25

Solutions: Add Capacity Through Hardware Upgrades u. Storage u. Server l. Scale up l. Scale out (RAC) u. Network Some Challenges! Ø Ø Doesn’t solve the root cause, “Hardware Acquisition Treadmill” One CIO observes: “Each time I buy storage, it requires more software, backup, array and bandwidth” 3/17/2018 26 26

Solutions: Decentralize or Do Not Consolidate u. Sometimes managing two medium-sized databases is easier than managing one large database Some Challenges! Ø Gives up all the advantages of consolidation − IT Operations − Consolidating reporting, etc… 3/17/2018 27 27

Solutions: Database Partitioning u. Oracle feature for managing large tables u. Improves performance if queries are able to use partition keys u“Life cycle” of data may leave active data in same partition as inactive data Some Challenges! Ø Does not address core data growth issue Ø Provides no help in compliance, data retention Ø Application must be tuned for partitioning 3/17/2018 28 28

Solutions: Database Archiving u. Remove data from OLTP Databases while retaining ability to access l. Database Backups/Snapshots l. Exports, CSV files l. XML Files or other self-describing format l. Relocation to secondary database u. Access via reporting tools or business analytics u. Access via native application l. Maintain full data integrity 3/17/2018 29 29

Database Archiving: Key Components High Sales order booked Change order Partial shipments Complete shipment Access / SLA Requirements Customer invoices generated Sales order closed Customer inquiry Internal audit Retrieval Activity Low Time Regulatory data retention period ends Corporate data retention period

Deploy Data By Cost and Class Of Service Compliance Data Source Home Inactive Data Grown Database Active Data Business Applications . XSD. XML

Database Archiving: Key Components Moderate Access r Analysisbase A ta o Da e Policy t. Management abas at D Business Transactions Configuration Database ng chivi Database to File Archiving Information Movement Archive Database Infrequent Access. XSD. XML Data Recovery Services base User Access Subs etting ARCHIVE PLATFORM QA QA Dev 2 3/17/2018 32 32

Agenda u. The Data Explosion u. Effects of Database Explosion l. End User l. IT Operations u. Solutions u. Q & A 3/17/2018 33 33

Conclusion u. Plan for archiving! u. Understand the impact of doing nothing u. Make it part of your Fusion strategy 3/17/2018 34 34

Plan for Archiving: Next Steps Data Collection Scripts (DCS) Offer u. Database measurement at a point in time l Snapshot u. Integral part of the Discovery process l Non-intrusive to actual data u. Provides data/module distribution l Oracle Applications l People. Soft u. Provides mappings to pre-packaged modules u. Understand growth trends & areas of growth 3/17/2018 35

Next Steps – How to Access DCS No-Cost Data Collection Script Analysis u. Customer receives SQL via email u. Script is run against production database u. Email results to John Sosnowski (john. sosnowski@hp. com) u. HP analyzes results and provides feedback & recommendations within 2 weeks u. Provides growth data & basis for ROI l - Storage optimization and projected performance increases 3/17/2018 36

Summary: The DCS Process DCS Script & Survey to Customer Non-intrusive Database SQL scripts capture table structure and storage information Customer runs DCS, completes survey & Returns via e-mail DCS Processing . out survey REPOS (send to ‘DCS’ alias) DCS Spreadsheet

Questions and Answers Thank you! Jeff Blackmon Jeffrey. blackmon@hp. com John Sosnowski John. sosnowski@hp. com www. hp. com/go/rim 4 db www. solutionbeacon. com Real Solutions for the Real World. ®