SAP/MAJESTY COIL Project Co-Verification of SAP and MAJESTY
11/12/2014 1 C 2014 JLIC Institute. Inc and Ssysbank
Member of SAP/MAJESTY COIL Project
SAP/ COIL Tokyo • Marc-san
• Minakuchi-san
• Inoue-san
MAJESTY/ SYSBANK Tokyo • Jung (Technical)
• Lee (Technical)
• Fukui (Strategic Alliance)
11/12/2014 C 2014 JLIC Institute. Inc and Ssysbank 2
COIL Project Summary SAP and MAJESTY
11/12/2014 C 2014 JLIC Institute. Inc and Ssysbank 3
RESULT of Database Performance Optimization by MAJESTY (COIL Project)
70
60 Classic SAP Original
(No Add-on)
SAP + Add-on
Performance Down !!
Optimizing Steps : 1. Visualized SQL, Index , Table … by MAJESTY 2. Indicated Appropriate Index design… by MAJESTY 3. Tuned the Database by an engineer using the
Indicated Appropriate Index design by MAJESTY
Phase 1 Phase 2 Phase 3
SAP + Add-on
70
Good Performance
Optimizing by using MAJESTY Monitoring by using MAJESTY Monitoring by using MAJESTY
Good Performance
11/12/2014 4 C 2014 JLIC Institute. Inc and Ssysbank
Features of MAJESTY
11/12/2014 5 C 2014 JLIC Institute. Inc and Ssysbank
MAJESTY can contribute to all phase of IT System Life Cycle
IT Consultation
Assessment / Proposal Plan Design Dev. Test Launch Monitor
IT Project IT Operation
Another Database Engineer
MAJESTY 11/12/2014 6 C 2014 JLIC Institute. Inc and Ssysbank
MAJESTY’s Features and other database tools
MAJESTY is able to find out issues of
database access through INDEX
optimizations, and is able to show the
solution as a heuristic way.
For example, MAJESTY provides the status
of database access patterns which make
low performance in a server systems.
Also, MAJESTY provides such analysis
results visibly and obviously.
So, even if an engineer who is not an
expert of database like as a Database
Administrator (DBA), the person can easily
optimize database and improve the system
performance as like a DBA.
Other tools
MAJESTY
Analysis of Objects
Access patterns
Analysis of INDEX(Overall)
Green 0006
Hunt 0008
<= Hunt
> Hunt
Allen 0007
Clarke 0003
Davis 0002
Ford 0005
Jones 0004
King 0001
<= Ford
> Ford
<= Clark
> Clark
Green 0006
Hunt 0008
<= Hunt
> Hunt
Allen 0007
Clarke 0003
Davis 0002
Ford 0005
Jones 0004
King 0001
<= Ford
> Ford
<= Clark
> Clark
Statistics
°è ±Þ °è ±Þ ±̧ °£ µµ ¼ö °è ±Þ °ª
1 -0.5~4.5 8 2.0 1252.82 4.5~9.5 3 7.0 169.43 9.5~14.5 6 12.0 37.94 14.5~19.5 7 17.0 43.35 19.5~24.5 5 22.0 280.26 24.5~29.5 5 27.0 779.57 29.5~34.5 0 32.0 0.08 34.5~39.5 1 37.0 505.6ÇÕ 35 3068.7
0.000
0.050
0.100
0.150
0.200
0.250
0.300
0.350
0 1 2 3 4 5 6
0.000
0.050
0.100
0.150
0.200
0.250
0.300
0.350
0 1 2 3 4 5 6
Analysis of INDEX (Partially)
Green 0006
Hunt 0008
<= Hunt
> Hunt
Allen 0007
Clarke 0003
Davis 0002
Ford 0005
Jones 0004
King 0001
<= Ford
> Ford
<= Clark
> Clark
Green 0006
Hunt 0008
<= Hunt
> Hunt
Allen 0007
Clarke 0003
Davis 0002
Ford 0005
Jones 0004
King 0001
<= Ford
> Ford
<= Clark
> Clark
Performance analysis
Database Buffer
Cache
Share
d
Pool
Redo
Log
Buffer
Utilization of CPU, Memories
DBMS parameters
Performance analysis of Hardware
(Dedicate DBMS platform analysis)
Small Mid High
Improvement Level
MAJESTY is an original tool of Performance Monitoring & Analysis for Oracle and SQL Server
11/12/2014 7 C 2014 JLIC Institute. Inc and Ssysbank
WEB Server
Application Server
Targeted Database Server * Oracle9i or later * SQLServer 2008 R2 or later
SQL Data
MAJESTY Client Windows ODAC10g or later .NET latest version
Request
MAJESTY
Repository
Oracle 10g or later SQLServer 2012
3. No Private Data (Data Security is safe)
Targeted System Servers
Analysis Result
2. Almost No CPU Load of Targeted Servers (No Agent program)
MAJESTY Server (PC)
*Express Edition is available
MAJESTY’s 3 features & System Configuration
1. No Need to Install Any program to the productive server
2. No Private Data (Data security is safe) 3. Almost No CPU Load of Targeted servers.
(No Agent program in the productive server, Testing server and Development server)
1. No Need to Install Anything (Inquiry Privilege Only)
Data Collection from the Dynamic View Data
8
Original Analysis Methodology of MAJESTY
Access Pattern Analysis
What is Access Pattern?
Majesty’s original Thought and Methodology
Information that analyzed SQL execution plan with
original know-how, and indicate “POINT”
Means the combination of access route and access
pass.
When SQL is run, it access to corresponding table. At
this time, to look for some data (=access route), it
access by using the way DBMS has (=access pass)
9
Access Route Access Path Pint
11/13/2014 C 2014 JLIC Institute. Inc and Ssysbank
Classic SAP Optimization Approach
SAP and MAJESTY
11/12/2014 C 2014 JLIC Institute. Inc and Ssysbank 10
SAP Optimization Approach (Current)
Approach with ABAP tool Approach with HANA
Application Layer
Database Layer
Classic SAP
time
11/12/2014 11 C 2014 JLIC Institute. Inc and Ssysbank
Approach by ABAP tool + MAJESTY
データベース レイヤ
MAJESTY
Application Layer
Database Layer
Classic SAP
3. More Effective Result
of Database
Performance
Time
Time
SAP Optimization Approach (using MAJESTY)
1.Reduce Workload 2.Reduce Cost
11/12/2014 12 C 2014 JLIC Institute. Inc and Ssysbank
(Current)
13
INDEX TABLE elapsed time → 67% shorten !!
All Tables elapsed time → 57% shorten !!
Result of Performance Improvement
The SAP system was running with good end-user performance at the launch. But, with the passage, the performance is lowered, then, End-user’s complaints have been generated so many…
MAJESTY’s POINT means; = 100 BEST ! > = 70 GOOD ! < 70 NEED to Tune
MAJESTY’s Point (Avr. and Min.)
Customer’s Pain
11/12/2014 C 2014 JLIC Institute. Inc and Ssysbank
SAP system (Add- On-ed) Performance Improvement Result by using MAJESTY
Optimizing Steps : 1. Visualized SQL, Index , Table … by MAJESTY 2. Indicated Appropriate Index design… by MAJESTY 3. Tuned the Database by an engineer using the
Indicated Appropriate Index design by MAJESTY
Improvement Result Before and After
11/12/2014 14 C 2014 JLIC Institute. Inc and Ssysbank
Pain/Issue of Customers
End user device Response Time
Background Process Time
Batch Process Time
Analysis Process Time
Inquiry Shopping Trade
Security Banking
Edu-cation
Game &
Enter-
tament
Manu-facturing
Business Area for Database Optimization is huge …
Project Effect Due date keeping/Quality keeping/Project cost saving/Workload reduction …
IT Cost Reduction Effect No need to extend server, disk and memory to get the good performance …
MAJESTY can contribute to various Customer’s Systems
…
MAJESTY Contributions
11/12/2014 15 C 2014 JLIC Institute. Inc and Ssysbank
Worldwide COIL Project of SAP Classic & MAJESTY (as an example image)
GERMANY JAPAN
11/12/2014 16 C 2014 JLIC Institute. Inc and Ssysbank
Target Classic SAP System
Database
MAJESTY Repository
MAJESTY Server (PC)
Server for ; • Production Server • Testing Server • Development Server
Assessment and Monitoring by Remote! • Monitoring of Classic SAP System • Analysis of SQL, Index, Table… • Suggest Appropriate Index Design…
Remote Co-work
Tuning ! • Tuning of Classic SAP System • Monitoring SQL, Index, Table… • Apply Appropriate Index Design…
Visualize/ Analysis
Data Collection
COIL Global Team Collaboration
… APJ
Business Theme
MAJESTY can be widely applied
MAJESTY Customer References (example)
Applied Scene
Target Organization
PO Deals
Effect
Appropriate SQL INDEX Design Design / Development /
Testing Dev. Div.
DB Design Div. DB System Tuning Deals High Performance
High Quality
Stable
Cost Reduce
Shorten Dev. Team
Keep Due date
Customer Retain / Satisfaction
SQL Tuning for Database Performance Testing / Operation /
Monitoring Operation Div. DB Performance up Deals
Safety Actions for DB Transfer/Version up Migration / Extension Migration Project Team Extension Project Team
DB Migration Deals
To keep SLA & Optimizing Application TCO Assessment / Proposal CEO/CIO/CxO
DB Assessment Deals DB Consultation Deals
MAJESTYを活用したビジネス事例(抜粋) MAJESTY can provide and support New Business Opportunity for SAP Classic install base Customers
11/12/2014 17 C 2014 JLIC Institute. Inc and Ssysbank
Customer Retain /
Satisfaction
For more detail information,
please contact;
Marc-san and Minakuchi-san of SAP / COIL Tokyo Office
Thank You!
11/12/2014 18 C 2014 JLIC Institute. Inc and Ssysbank
Top Related