IT SAPSD Performance

Information about IT SAPSD Performance

Published on November 6, 2007

Author: Yuan

Source: authorstream.com

Content

SAP SD Performance Tuning - Xbox and the Need for Speed -:  SAP SD Performance Tuning - Xbox and the Need for Speed - Christoph Schuler, Cindi McCutchen SAP Application Support Microsoft Corporation Agenda:  Agenda SAP at Microsoft – Quick Facts Why Performance Tuning SAP Service Offerings Project Approach & Best Practices Tuning for Xbox Changes Implemented Summary of Results Lessons Learned SAP at Microsoft Quick Facts:  Modules implemented: SD, MM, FI, CO, AM, HR, BW, APO 875 GB in a single, central Database; 6 GB/wk growth 2,000 named users; 50,000+ total users > 600 concurrent users; heavy EDI usage 0.5 - 2 sec response time globally (incl. WAN connectivity) 99.9+% availability Platform: SQL Server 2000, Windows .NET server SAP at Microsoft Quick Facts Why Performance Tuning ?:  Why Performance Tuning ? Business need for data throughput Xbox Launch North America, Nov. ’01: * Each order & delivery with 10 line items Why Performance Tuning ?:  Why Performance Tuning ? System availability & supportability Prevention of: Cross-module increase in response time Business disruptions Penalties End user frustration Increased support costs System scalability Ability to handle future growth SAP Service Offerings:  SAP Service Offerings Focus on critical SD business processes 50+ recommendations to improve performance Interface Management Technical Solution Optimization (TSO) Now: Solutions Management Optimization (SMO) Business Process Optimization Data Mgmt. & Archiving Jun ‘00: EDI Interface GBI Interface Sep ‘00: Sales Orders Backorder Resch. Deliveries Billing Oct ‘00: FI Archiving Project Approach:  Project Approach Project team Functional Basis/Technical Development Stress Test Consulting (BUIT & SAP) Project timeline Driven by business need Repetitive cycle One item at a time Project metrics e.g. seconds/document Test Best Practices:  Test Best Practices Have an original baseline test Automate tests and standardize your data & configuration Include anticipated new functionality (e.g. routing, allocations) Consider systems external to SAP Make test as realistic as possible ! Analysis Best Practices:  Analysis Best Practices Define your metrics (e.g. sec/doc, response time, etc..) Carefully document results and improvements with each cycle Review results and plan for next changes to be implemented and tested Analysis Useful Tools & Transactions:  Analysis Useful Tools & Transactions Systemwide work process overview – SM66 Workload monitor – ST03 SQL trace - ST05 SQL trace interpreter - SQLR Application analysis – ST14 Table access statistics – ST10 Memory configuration monitor – ST02 R/3 OS monitor – ST06 IDoc monitor – WE05 Gateway Monitor - SMGW Windows PerfMon – CPU utilization Analysis Process Overview - SM66:  Analysis Process Overview - SM66 Quick overview of all work processes Look for: Long-running processes “Stopped” processes Highly utilized servers Processes accessing the same tables Analysis Database Trace - ST05:  Analysis Database Trace - ST05 Important tool to analyze database performance problems Look for: Most “expensive” database accesses (Trace Summary) Repetitive database accesses Change Best Practices:  Change Best Practices Changes may include: OSS notes (> 2,600 performance notes for 4.5B) ABAP code optimization Configuration Technical settings Hardware Business process or logic Carefully document changes made Analysis Change Agenda:  Agenda Why Performance Tuning SAP Service Offerings Project Approach & Best Practices Tuning for Xbox Changes Implemented Summary of Results Lessons Learned Slide15:  Microsoft (SAP System) Tuning for Xbox Sales Order Distribution Warehouse Sales Order (EDI 850) 1 Retailer Slide16:  Tuning for Xbox 1 – Sales Order Processing Switch to parallel processing of inbound IDocs Partner profile change: ’Immediate’ to ‘Background’ (via WE20) Server group configuration with resource parameters (via RZ12) –OSS 384971 Schedule program RBDAPP01 Specify packet size and ‘Parallel’ posting option Deactivate IDoc syntax check Increase of program buffer Slide17:  Tuning for Xbox 1 – Sales Order Processing SD number range buffering Table NRIV - Object RV_BELEG (via SNRO) Local buffering by work process ID Exclusion of sales orgs (OSS note 424486) ABAP code improvements VA01 user exits Elimination of repetitive table reads Table buffering Monitor access statistics (via ST10) Slide18:  Tuning for Xbox Sales Order 2 Rescheduling Retailer Sales Order (EDI 850) 1 Distribution Warehouse Microsoft (SAP System) Slide19:  Tuning for Xbox 2 - Backorder Rescheduling Cleanup of old orders Program SDV03V02 by plant – daily Evaluation of program SDV03V01 Modification (repair) of SDV03V02 Due to SD number buffering Take order creation date & time into account Custom pre-processing program Dynamic job builder and distribute workload over several processes Utilize standard SAP programs Tuning for Xbox:  Tuning for Xbox Sales Order Delivery 2 Retailer Sales Order (EDI 850) 1 Distribution Warehouse Ship Order (EDI 940) 3 Rescheduling Microsoft (SAP System) Slide21:  Tuning for Xbox 3 – Delivery (EDI Ship Order) Custom pre-processing program: Dynamic job builder and distribute workload over several processes Utilize standard SAP program (RV50SBT1) Additional index on table VBBE Separation of output from document creation Schedule RSNAST00 to process output Schedule RSEOUT00 to process IDocs and combine into files Slide22:  Tuning for Xbox 3 – Delivery (EDI Ship Order) Deactivate IDoc Syntax Check SD number range buffering Activate shared locking For availability checking group level for ATP (via OVZ2) Evaluate program RVV50R1T (VL10) instead of current DDL Program was evaluated but not implemented Server group functionality is available in SAP version 4.6c Tuning for Xbox:  Tuning for Xbox Sales Order Delivery Goods Issue Ship Order (EDI 940) Ship Confirm (EDI 945) Shipment 3 4 5 2 Rescheduling Sales Order (EDI 850) 1 Distribution Warehouse Retailer Microsoft (SAP System) Slide24:  Tuning for Xbox 5 – Post Goods Issue (EDI Ship Confirm) Switch to parallel processing of inbound IDocs via RBDAPP01 Same as sales order processing Table Locking – MVER (OSS Note 318581) Prevent plant locking Allow IDOC to be reprocessed (from a status 64) instead of going into an error (status 51) Activate ‘Late exclusive enqueue’ For material movements via OMJI (OSS 192423) Deactivate IDoc syntax check Tuning for Xbox:  Tuning for Xbox Distribution Warehouse Sales Order Delivery Billing Goods Issue Invoice (EDI 810) Shipment 4 6 2 Sales Order (EDI 850) 1 Ship Order (EDI 940) Ship Confirm (EDI 945) 3 5 Rescheduling Retailer Microsoft (SAP System) Slide26:  Tuning for Xbox 6- Billing SD number range buffering Exclude certain countries due to legal requirements (OSS Note 23835, 363901) Parallel processing of billing due list Program RV60SBAT, specify ‘Number of jobs’ Separation of output from document creation Schedule RSNAST00 to process output Schedule RSEOUT00 to process IDocs Slide27:  Tuning for Xbox Additional Changes Implemented ATP server (Available to Promise) Information in OSS note 99999 Installed on central instance Tax solution (Vertex) upgrade Use ‘Registered RFC mode’ (OSS 63930) APO RFC calls (Advanced Planning Optimizer) RFC queue in R/3 spawning ARFC* jobs Slide28:  Tuning for Xbox Summary of Testing Results SD Core Transactions: Slide29:  Tuning for Xbox Summary of Results Xbox Transaction Volume Xbox Transaction Performance Slide30:  Tuning for Xbox Summary of Lessons Learned Utilize SAP/OSS resources Assemble a project team with a wide range of knowledge Only test ONE change at a time Be prepared to spend about 80% of your time testing And learn to hide from the Basis team  Slide31:  References “SAP R/3 Performance Optimization” by Thomas Schneider, Sybex “ALE, EDI & IDoc Technologies for SAP” by Arvind Nagpal, Prima Tech Slide32:  Questions?? Slide33:  Cindi McCutchen & Christoph Schuler Microsoft Corporation Email: [email protected] or [email protected]

Related presentations


Other presentations created by Yuan

ISPS Code Final
05. 11. 2007
0 views

ISPS Code Final

6 Flexural Component Design
04. 01. 2008
0 views

6 Flexural Component Design

ABAPresentation
13. 04. 2008
0 views

ABAPresentation

eBDSinGMS
27. 03. 2008
0 views

eBDSinGMS

NM
14. 03. 2008
0 views

NM

market forces
24. 02. 2008
0 views

market forces

VesnaDamnjanovic
20. 02. 2008
0 views

VesnaDamnjanovic

Meeting1
07. 01. 2008
0 views

Meeting1

Age of Limits
07. 01. 2008
0 views

Age of Limits

Deviance
04. 01. 2008
0 views

Deviance

ijcai distinguished 01
27. 09. 2007
0 views

ijcai distinguished 01

sunum VS2008
28. 11. 2007
0 views

sunum VS2008

Stamatakis18 3 04
29. 11. 2007
0 views

Stamatakis18 3 04

cam
04. 12. 2007
0 views

cam

KfW short
24. 10. 2007
0 views

KfW short

Hist12 f Mussolini
31. 10. 2007
0 views

Hist12 f Mussolini

kanwar presentation
02. 11. 2007
0 views

kanwar presentation

SpadaPlanck07 ThePhysicsAMS 02
29. 10. 2007
0 views

SpadaPlanck07 ThePhysicsAMS 02

shiphandling
07. 11. 2007
0 views

shiphandling

newslink volkswagen case study
16. 11. 2007
0 views

newslink volkswagen case study

LBL SC Seminar
20. 11. 2007
0 views

LBL SC Seminar

The Divine Flute Vamshinew
22. 11. 2007
0 views

The Divine Flute Vamshinew

MACEDONIA Brussels June 2007
23. 11. 2007
0 views

MACEDONIA Brussels June 2007

5 MotionDance1
23. 11. 2007
0 views

5 MotionDance1

pneumonia
28. 12. 2007
0 views

pneumonia

Adjective Clauses
29. 12. 2007
0 views

Adjective Clauses

GBB Victoria
29. 10. 2007
0 views

GBB Victoria

2002aahe sotlbridges
01. 01. 2008
0 views

2002aahe sotlbridges

PresentationKaycaCot ton
15. 11. 2007
0 views

PresentationKaycaCot ton

IRSIS
07. 11. 2007
0 views

IRSIS

Dempsey Diane
06. 11. 2007
0 views

Dempsey Diane

Tana Jan07
31. 12. 2007
0 views

Tana Jan07

PPT 29
04. 10. 2007
0 views

PPT 29

umcineurasia
26. 10. 2007
0 views

umcineurasia

Jatoi
03. 01. 2008
0 views

Jatoi

B01HumEco2004
24. 10. 2007
0 views

B01HumEco2004

Predator prey interactions
30. 12. 2007
0 views

Predator prey interactions

Ullman Impact
28. 11. 2007
0 views

Ullman Impact

slides 1 28 05
28. 12. 2007
0 views

slides 1 28 05

RockMinerals 2008SHOW
06. 12. 2007
0 views

RockMinerals 2008SHOW

Floriculture and Floral Design
11. 12. 2007
0 views

Floriculture and Floral Design

atv driptorch
12. 11. 2007
0 views

atv driptorch

TUNISIA
31. 10. 2007
0 views

TUNISIA

DePaoloERSP40406
08. 11. 2007
0 views

DePaoloERSP40406

DixonMonBatchProcess Vents
06. 11. 2007
0 views

DixonMonBatchProcess Vents

NintendoForwardChain ing
24. 12. 2007
0 views

NintendoForwardChain ing

Ozturk tsaps Oct6
01. 11. 2007
0 views

Ozturk tsaps Oct6

NZ Beech Forest
02. 01. 2008
0 views

NZ Beech Forest

Portugal project Tyler
26. 11. 2007
0 views

Portugal project Tyler

DO Lect6
19. 11. 2007
0 views

DO Lect6

Ch 20 powerpoint
03. 10. 2007
0 views

Ch 20 powerpoint

session23 lowenthal
30. 11. 2007
0 views

session23 lowenthal

the flowers of bermuda
14. 12. 2007
0 views

the flowers of bermuda

sw week april06
29. 10. 2007
0 views

sw week april06