Online Tutorials & Training Materials | STechies.com
Register Login

Data Volume Management (DVM) Interview Question and Answer

|| || 0

Data Volume Management (DVM) Interview Question and Answer
Stechies

SAP Data Volume Management (DVM) FAQ

How to find out, that this guided self service helps me to improve my solution? What are the alerts, KPI's in my solution, that helps me to decide to run this GSS?

a.) Service is only valid for ABAP based components.

b.) An alert for data and storage management is raised in an EarlyWatch Alert report. 

b.1.) This alert comes up, if DB size and DB growth exceed the numbers in the table below. In case the alert is raised, a GSS for Data Volume Management is recommended.

You can find information about DB size and DB growth of your system in chapter 'Database Adminstration' of the EarlyWatch Alert report.

System Component Database Size (GB) Yearly growth (%)
APO 250 30
BW 250 30
CRM 250 30
ERP (based solutions) 250 20
Exch. Infrastruct. 250 30
Netweaver PI 250 30
R/3 250 20
R/3 Enterprise 250 20
SCM 250 40
SEM 250 30
SRM 250 40
Others 250 30

b.2.) In case that your SAP Solution Manager system and your managed system(s) meet the technical requirements and in case that the DVM content is activated for the, five database objects are proposed by the EWA report which show potential for data reduction to be achieved by e.g. data archiving or deletion of data. The Saving Potential is determined based on the header table of the document type. Here, the following rules are applied: For Basis and Cross-Application all tables / indexes older than 6 month are considered as saving potential. In addition, for application data all tables / indexes all tables older than 24 month are considered as saving potential. An alert for data and storage management in an EarlyWatch Alert report indicates a saving potential of more than 10 % for an object. In case the alert is raised, a GSS for Data Volume Management is recommended. You can find additional information in chapter 'Data Volume Management' of the EWA report.

c.) If no Early Watch Alert data are available, important KPI to analyze are DB size and DB growth. In case the numbers measured in your system exceed the numbers in the table below, this service helps to find potential for improvement

System Component Database Size (GB)   Monthly growth (GB)
  Recommended Mandatory  
  from from  
ERP (based solutions) 500 800 30
BW / SEM 500 800 30
CRM 300 500 15
SRM 300 500 15
SCM - APO/EWM 300 500 15
PI/XI 300 500 15
Banking Services 800 1000 100
Bank Analyzer 800 1000 100
Others 300 500 15

Is there any special procedure to run this GSS?

No

What is the result of this GSS?

As a result you will get a report with the analysis result dependent on the chosen objects, recommendation on possible next steps and possible options in terms of:

  • Data avoidance
  • Data summarization
  • Data deletion
  • Data archiving
  • Calculation of saving potential

Necessary Follow Up activity is to discuss with Business the different recommendations and the way to implement it.

What are the benefits of this GSS?

  • Minimization of disk usage
  • Optimization of data volume
  • Improvement of performance in special cases

Please find an example for a resulting word document with recommendations, etc. in the attachments of this SAP .

How often or in what sequence shall I run this GSS?

There is no general recommendation. Via EWA or system monitoring , DB size and growth can be monitored and used as trigger for subsequent use of this GSS. Alternatively Install  DVM Cockpit (SolMan 7.0) or setup DVM workcenter (SolMan 7.1), define KPI's and alerts and use this as trigger for the next GSS delivery

What are the technical prerequisites of my service?

Details are described in SAP 1487247

How can I create a GSS for DVM?

There are two ways to create a GSS for DVM:

1. SAP Engagement and Service Delivery Workcenter

You can access the SAP Engagement and Service Delivery Workcenter with transaction SM_WORKCENTER. Here you can navigate to 'Services'. After using button 'Create', a popup comes up. Here you can select 'Data Volume Management'. Follow the procedure to create a Guided Self Service for DVM with button 'Next' and confirm the creation of the Guided Self Service with button 'Finish'. A new browser window will open with your new Guided Self Service for DVM.

2. Data Volume Management Workcenter

You can access the Data Volume Management Workcenter with transaction SM_WORKCENTER. Here you can navigate to 'Service Documents'. Again after using button 'Create', a popup comes up guiding you through the steps to create a Guided Self Service for DVM (as described above).


Related Articles