DVM – Analysis & Monitoring – Cloud Solution

Introduction
Target Group
The DVM Service for SAP S/4HANA is targeted towards:
IT Manager
 Find optimization potential in different S/4 HANA systems of IT landscape
 Reduce IT cost through better utilizing available memory resources and disk space
DVM Project Manager
 Determine reduction potential in S/4 HANA system
 Focus on optimal methodology for data reduction (right tool for required reduction area)
DVM Expert
 Detect reduction potential on different areas (Memory and Disk)
 Find proper tools for reduction, such as Aging, Archiving and Deletion
 See impact of data reduction measures

© 2019 SAP AG. All rights reserved. 3

DVM Cloud Application
Availability
DVM Cloud Application – One Support Launchpad
Standalone Dashboard
– Available for all customers since July 2018
Integration into SAP Solution Manager 7.2 (Sp03)
 SAP S/4 HANA
– Available as CQC Service (since August 2018)
– Available as Self Service (as of October 2018)
 SAP_FIN (sFIN / cFIN)
– Reduced scope of analysis content
– Same availability as S/4 HANA
 SAP HANA
– Availability planned for 2019

© 2019 SAP AG. All rights reserved. 4

Access DVM Cloud Application via SAP One Support Launchpad

© 2019 SAP AG. All rights reserved. 5

Product Overview and Focus Areas

▪ Main Product Focus: ‘Classic’ SAP Business Suite on Any DB

▪ Support decision making process on data reduction possibilities / archiving concepts
▪ Support Customers in preparing transition to HANA and S/4 HANA
▪ DB specific tools (e.g. Reorg and Compression App)

DVM Applications
(SolMan 7.20)

▪ Main Product Focus: ‘Next Generation’ products (SAP S/4HANA)

▪ Supported Databases: HANA only
▪ Insights into all kinds of data reduction methods (technical + application related)
▪ Support Customers in S/4 HANA operations (from DVM perspective)

DVM Cloud

© 2019 SAP AG. All rights reserved. 6

Architecture
Overview Architecture

SCP Public Account supportshell-supportportal

Customer Solution W71/W72 CBP

Manager

Customer Managed
System
I7P/OSP

© 2019 SAP AG. All rights reserved. 8

Integration with Service Delivery
 Service Delivery Process
Order DVM CQC Service
DVM Service Session

Push data Final

CRM@SAP Collect
DVM Self-Service to SAP Cloud DVM Analysis
raw data
Session for analysis

SAP Solution Manager S/4HANA System SAP Backend SAP Cloud Platform

DVM Self-Service

S/4HANA System
• Order CQC DVM service • DVM CQC Service Session is • Raw data about data • SAP Solution Manager • Customer receives Email
(for a system running SAP generated in SAP Solution volumes are collected from pushes data into SAP Cloud about completed analysis
S/4HANA) Manager on premise managed system (SAP
S/4HANA): • Alternatively raw data from • Email contains link to SAP
• Addiontally, delivery as self- • DVM Self-Service session can • Collection of technical S/4HANA System can be Cloud (via SAP ONE Support
service is possible be created in SAP Solution metrics such as table sizes, uploaded directly in the DVM Launchpad)
Manager historic distribution of data Cloud Application
etc. • Analysis is available as Cloud
• In case, no SAP Solution • Execution of application • Raw data are analyzed based App for navigation and drill
Manager is available, self- related potential analysis on residence times down.
service can be started from (e.g. archiving, aging For CQC Service, additionally
S/4HANA System itself potential) DVM report document is
• Technical SQL scripts for prepared.
potential on HANA DB

© 2019 SAP AG. All rights reserved. 10

Email Notifications

Email with Link to Analysis UI received by processor of service

 Service data download is finished

 Service raw data are evaluated
 Service result is persisted
 [Service Report is prepared - in case of CQC]
 Email with link to DVM Cloud Application is sent

© 2019 SAP AG. All rights reserved. 11

Data Collection

• An alternative data collection process is available via the SDCCN tool.

• Details can be found in the SAP KBA Note: 2746840

Benefits
• Cloud Solution always has data
• No need to order a specific service to populate the cloud solution
• Persistence of data will enable Machine Learning based triggering of services/activities

© 2019 SAP AG. All rights reserved. 12

DVM Cloud Application
User Interface – Main screen
The Main screen shows a wealth of information at a glance
• System & Client
• Analysis Date
• Memory Usage
• Disk Usage
• Memory Usage Reduction Potential
• Disk Usage Reduction Potential
• Custom table Statistics
• Technical SAP HANA Analysis
• Memory Usage Reduction Potential - Options
• Disk Usage Reduction Potential - Options
• Age-based data distribution

You can drilldown from the main screen on any of the

cards/tiles to get further information.

© 2019 SAP AG. All rights reserved. 14

 Example – Optimize Memory Usage

A ranked list of
reduction objects
based on reduction
potential.
• Can be filtered by
method i.e. Aging,
Archiving, Deletion.
• Can be displayed in
Tabular or
Graphical format

© 2019 SAP AG. All rights reserved. 15

Example - Memory Reduction Potential – Simulate
Simulation Function
• Model the impact of
custom residence
times on reduction
potential
• Custom residence
times can be saved.
All predictions can be
based on these.

Custom residence time

and reduction potential

© 2019 SAP AG. All rights reserved. 16

Example - Custom Table Footprint

Dashboard
showing the top
custom tables (by
size) in the
analyzed system.
• Metrics shown –
Disk Size,
Estimated Max.
Memory Size
and Record
Count.

© 2019 SAP AG. All rights reserved. 17

Technical Analysis – example Largest Memory Consumers
A range of analyses are available providing deep technical insights to the data – A full list is provided in a
later slide.
Note:
The tile on the landing page is dynamic and reflects the number of SQL statements the current snapshot was able to execute e.g. in this slide
we can see “6” in the tile, but there are at least 13 statements delivered via the cloud solution.

© 2019 SAP AG. All rights reserved. 18

Technical Analysis – example Tables with > 1 Billion rows
The technical analysis results are presented in tabular form. The displayed columns are customizable using
the “personalization” icon

© 2019 SAP AG. All rights reserved. 19

Drilldown from Age of Records to Application
Drilldown features allow navigation from the Distribution of Analyzed
Records by Time to the Distribution of Records by Application Area.
Further drilldown to sub-application and switch to the raw data is possible.
Showing the number

© 2019 SAP AG. All rights reserved. 20

Share information
Every dashboard can be shared via email with relevant recipients.
Every dashboard has it’s own dedicated URL.

Use the email icon. A draft email is

proposed as follows. Edit as required to
convey your message.

© 2019 SAP AG. All rights reserved. 21

SQL Scripts in DVM Content
Description in Cloud Description
Memory & Disk Overview HANA Memory and Disk Usage overview

Largest Memory Consumers Areas in HANA with highest memory requirements

Row Store Overview HANA Row store overview including allocated space and fragmentation

Save Using HASH Indexes Calculation of space savings when migrating to inverted hash indexes

Tables > 1 billion rows HANA largest tables with more than 1 billion records

Largest Tables on Disk HANA largest tables by disk size

Largest Tables in Cur Mem HANA largest tables by current memory

Top Growing Tables – Disk Displays top 50 tables with highest growth in disk size

Top Growing Tables – CM Displays top 50 tables with highest growth in current memory

Top Growing Tables – MM Displays top 50 tables with highest growth in estimated maximum memory

Top Shrinking Tables - Disk Displays top 50 tables with highest shrinking / reduction in disk size

Top Shrinking Tables – CM Displays top 50 tables with highest shrinking / reduction in current memory

Top Shrinking Tables - MM Displays top 50 tables with highest shrinking / reduction in estimated maximum memory

© 2019 SAP AG. All rights reserved. 22