dvm cockpit
TRANSCRIPT
Data Volume Management Cockpit
Dominik HeldSAP Active Global SupportOctober 2009
© SAP AG 2009. All rights reserved. / Page 2
Agenda
1. ObjectivesCentralized Information Cockpit
2. ArchitectureIntegration into SAP Solution Manager 7.0 EhP1Extractor Framework
3. Demo4. Availability
Prerequisites
© SAP AG 2009. All rights reserved. / Page 3
Agenda
1. ObjectivesCentralized Information Cockpit
2. ArchitectureIntegration into SAP Solution Manager 7.0 EhP1Extractor Framework
3. Demo4. Availability
Prerequisites
© SAP AG 2009. All rights reserved. / Page 4
Data Volume Management CockpitObjectives
Establish a Centralized Information Cockpit forData Volume Management
Get Transparency on Landscape’s Data andImpact of planned change events on data growth
Detect biggest ‚Consumer‘ of data
Reveal Potential for Creating / Optimizinga Data Volume Strategy
‘Simulate’ different Data Volume Scenarios
Provide Monitoring/Reporting/Alerting Capabilities
Enable automatic Compliance Checks ofCorporate Data Volume Strategy
© SAP AG 2009. All rights reserved. / Page 5
Data Volume Management CockpitInformation Cockpit
DVM Cockpit as a ‚Data Lifecycle Management‘ ToolPlanning Environment for
System Landscape Capacity PlanningResource Management of Data Volume ProjectsFuture solution change events (Migration / Upgrade)
Management Information SystemIndividual role-based Dashboard configurationUse of an adaptable and flexible BI modeling environment
© SAP AG 2009. All rights reserved. / Page 6
Data Volume Management CockpitInformation Cockpit
‘Single source of truth for DVM’Technical Information of DB Objects (size, growth, entries, indexes…)Providing different views on DB data, e.g.
Product / Product VersionSystemApplication AreaBusiness UnitDocument TypeArchiving ObjectTable / Index
Age of data records (histogram of data)Calculation of Saving Potential for selected Document TypesOverview of Executed Archiving RunsArchive Run InformationArchive File Statistics
© SAP AG 2009. All rights reserved. / Page 7
Data Volume Management CockpitImpact of Change Events
Transparency on how Solution Transition Events affect Data VolumeVarious effects resulting from a transition event, such as
Increased table growth (e.g. functional changes, structure changes etc.)New tables used (e.g. upgrades, EhP, Custom Code)Existing Data might become obsolete (process changes, technical changes)Adjustment of archiving and deletion strategy requiredNew requirements on capacity planning
Consolid.
NewImplem.
Upgrades
CustomDev.Support
Pack
HotPacks
Eff
ort
OngoingChangeEvents
Newprocesses
DiscreteChangeEvents
CustomDev.Support
Pack
CustomDev.
© SAP AG 2009. All rights reserved. / Page 8
Data Volume Management CockpitRevealing Potential
Reveal Potential for Creating / Optimizing a Data Volume StrategyCreating Archiving Strategy
Revealing top objects per systemProvides basis for decisions on priority (histograms of tables)Identifying Top Archiving / Deletion Objects
Optimizing Archiving StrategyReveals potential strategy lacksProvides clear basis to improve strategy (technical)Delivers fundamentals for adjusting residence times (organizational)
© SAP AG 2009. All rights reserved. / Page 9
Fundamentals for ‚IT as a Service‘
Data Volume Management CockpitDetect Biggest Consumer (*)
Vertical view on data from a ‚Business Perspective‘
Current Situation:Increasing number of global core systemsCentralized data sharing by multiple organizational unitsProcesses are the same but data consumption differsLack of data allocation visibility on organizational level
DVM Cockpit provides:Business unit centric (e.g. company code) drilldown into data allocationReal business view on dataEasy detection of mismatch between business volume and data consumptionInsights into data distribution for cost assignment
(*) Available as of SAP Solution Manager 7.0 EhP2
© SAP AG 2009. All rights reserved. / Page 10
Data Volume Management CockpitCompliance Check / Alerting
Compliance Check of Corporate Data Volume StrategyCompliance of a corporate Data Volume Strategy can be monitored automatically:
Globally defined residence timesPermitted document volume / system‘s data growth quota per– Organizational Unit / Business Unit– Application Area– Document Type– Period (day, week, month, quarter, year)Forecasting– Alerting based on BI trend analysis
© SAP AG 2009. All rights reserved. / Page 11
Agenda
1. ObjectivesCentralized Information Cockpit
2. ArchitectureIntegration into SAP Solution Manager 7.0 EhP1Extractor Framework
3. Demo4. Availability
Prerequisites
© SAP AG 2009. All rights reserved. / Page 12
DataCollectors
Extractors
Data Volume Management CockpitArchitecture Overview
DatabaseStatistics
(DB02)
SCM
TAANAST-A/PI(DVM Content)
CRM ERP …
Scenarios
SAP Solution Manager
SAP BusinessProcess MonitoringExtractor Framework
Work Center,BI Dashboards &Queries
CustomerCustomer
© SAP AG 2009. All rights reserved. / Page 13
Data Volume Management CockpitExtractor Framework
© SAP AG 2009. All rights reserved. / Page 14
Data Volume Management CockpitInformation Backflow
Seamless integration into DVM PortfolioMain pillar of enhanced DVM portfolio
Implementing a permanent and reliable source for DVM analysis on customer sideIntegrated in SAP Solution Manager strategy
Continuous Improvement by Information BackflowImplementing ‚lesson learned‘ feedback from SAP service deliveries (Best Practice)Regular DVM content update (based on SAP experience)
Customer
DVM Knowledge Base built on
SAP Active Global Support Deliveryof DVM Services
Customer Feedback
Partner Feedback
Access to SAP Experience
SAP Data Volume ManagementService Delivery
SAP Data Volume Self Service(Best Practice) *
Data Volume Cockpit Content
DVM Expert On Demand
DVMKnowledge
Base
* Available as of Q2 2010
© SAP AG 2009. All rights reserved. / Page 15
Agenda
1. ObjectivesCentralized Information Cockpit
2. ArchitectureIntegration into SAP Solution Manager 7.0 EhP1Extractor Framework
3. Demo4. Availability
Prerequisites
DEMO
© SAP AG 2009. All rights reserved. / Page 17
Agenda
1. ObjectivesCentralized Information Cockpit
2. ArchitectureIntegration into SAP Solution Manager 7.0 EhP1Extractor Framework
3. Demo4. Availability
Prerequisites
© SAP AG 2009. All rights reserved. / Page 18
Data Volume Management CockpitAvailability
SAP Data Volume Management Cockpit is part ofSAP Solution Manager 7.0 EhP1
General PrerequisitesSAP Solution Manager 7.0 EhP1 SP 18 (20 recommended)Source System:– Newest versions of ST-PI and ST-A/PI Plug-Ins– SAP_BASIS as of 4.6C
Application or release pecific requirements documented in– SAP Note 1159758– SAP Note 1233709
Thank You!
© SAP AG 2009. All rights reserved. / Page 20
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained hereinmay be changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries,eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+,POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex,MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.
Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or othercountries.
Oracle is a registered trademark of Oracle Corporation.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.
HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.
Java is a registered trademark of Sun Microsystems, Inc.
JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.
SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respectivelogos are trademarks or registered trademarks of SAP AG in Germany and other countries.
Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products andservices mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries.Business Objects is an SAP company.
All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only.National product specifications may vary.
These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only,without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Groupproducts and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construedas constituting an additional warrant.
Copyright 2009 SAP AGAll Rights Reserved