PBS Analysis Tools
Effective Database Analysis for SAP ERP and SAP BW
Agenda
PBS Database Analyzer PLUS
Capacity Analysis and Document Distribution in SAP ERP
PBS BW Database Analyzer
Capacity Analysis and Data Distribution for InfoProviders in BW
PBS Database Analyzer PLUS
Effective utility to evaluate and monitor important database parameters and support
data archiving projects. Two different analysis options can be used:
Database Capacity Analysis
Analyze table size and space occupation in the database, grouped by SAP
archiving objects. Various result evaluation options (overview, dedicated details,
correlation to PBS add-on modules. Run periodically for growth rates. Supports:
Oracle, MS-SQL, Informix, MaxDB, DB2, AS400.
Document Distribution Analysis
Capacity Analysis for SAP ERP
Initialization:
Evaluate important system
settings for proper analysis runs
Start an analysis run
:
Selection options to
define analysis details
Capacity Analysis for SAP ERP
The results evaluation provides
various options to display the
analysis information
Capacity Analysis for SAP ERP
Comparison analysis:
compare results of two
different analysis runs
Detailed analysis results: List includes
all tables
which are covered from a dedicated archiving object.
First run Second run Difference
Document Distribution for SAP ERP
A dedicated evaluation program is used to
displays the analysis results
Document Distribution for SAP ERP
Analysis review:
BKPF distribution details
according to selection above
Selection screen for analysis review of
FI data
,
PBS BW Database Analyzer
Effective utility to evaluate and monitor important BW database parameters and
support nearline storage / archiving projects. All BW InfoProviders are evaluated.
BW Database Capacity Analysis
Analyze the data amount and space occupation
in the database for BW InfoProviders and
generate a hitlist (largest InfoProviders). Run
periodically for growth rates. Supports: Oracle,
MS-SQL, Informix, MaxDB, DB2, AS400.
Data Distribution Analysis
Analyze the data distribution for all BW
Capacity Analysis for SAP BW
Configure an analysis run according to
the individual evaluation needs:
InfoProvider selection with limitation option
for dedicated Providers and table spaces.
Additional selection options for InfoCubes
and PSA tables.
Restriction to InfoProviders with active
data archiving process (DAP)
Periodic processing allows monitoring of
Capacity Analysis for SAP BW
Capacity Analysis for SAP BW
Comparison analysis: Evaluate different runs to determine data growth and largest growing
InfoProviders.
Distribution Analysis for SAP BW
Evaluate data distribution for InfoProviders
either reference to a previous capacity
analysis run, or by entering dedicated Info
Providers which are to be analyzed.
Prioritize time characteristics
Additional user defined characteristics for
Distribution Analysis for SAP BW
Display data distribution by time characteristics (year, period)
Summary
Easy installation and configuration – quick analysis success
Overview of data distribution with drill-down options
Ideal support to setup data archiving and nearline storage projects
Periodic usage provides growth information and helps to control DB size
PBS Software GmbH
Schwanheimer Strasse 144a
64625 Bensheim
Phone:
+49-6251-174 0
Fax:
+49-6251-174 174
Email:
[email protected]
Internet:
www.pbs-software.com
Copyright
© Copyright 2013 PBS Software GmbH. All rights reserved.
No part of this presentation may be reproduced or transmitted in any form or for any purpose without the written permission of PBS Software GmbH. The information of this presentation might change without prior notice.
Microsoft, Windows are registered trademarks of Microsoft Corporation.
IBM, IBM DR550, IBM TSM and SSAM are trademarks or registered trademarks of IBM Corporation. Linux is a registered trademark of Linus Torvalds in the USA and other countries.
UNIX is a registered trademark in the USA and other countries, licensed exclusively through X/Open Company Limited. HP, HP-UX11 Apache are trademarks or registered trademarks of Hewlett-Packard Company.
EMC, EMC Centera, EMC Celerra are trademarks or registered trademarks of EMC Corporation. Hitachi, Hitachi HCAP, Hitachi HCP are trademarks or registered trademarks of Hitachi Ltd. NetApp, NetApp Filer are trademarks or registered trademarks of NetApp Corporation. Sybase IQ is a registered trademark of Sybase an SAP Company.
Actian Vectorwise is a registered trademark of Actian Corporation. PBS archive add ons is a registered trademark of PBS Software GmbH.
SAP, R/3, SAP NetWeaver, SAP NetWeaver Business Warehouse, SAP Industry Solutions and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.
All other product and service names mentioned are the trademarks of their respective companies.
