1 / 36

JD Edwards EnterpriseOne

JD Edwards EnterpriseOne. Performance Tuning Tips Session ID:100520. PRESENTERS. John Bassett Executive Vice President Global Systems Integration, Inc . Tom Gabriele Director of Delivery Global Systems Integration, Inc . AGENDA. Introductions / Agenda Performance Tuning

jemma
Download Presentation

JD Edwards EnterpriseOne

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. JD Edwards EnterpriseOne Performance Tuning Tips Session ID:100520

  2. PRESENTERS John Bassett • Executive Vice President • Global Systems Integration, Inc. Tom Gabriele • Director of Delivery • Global Systems Integration, Inc.

  3. AGENDA Introductions / Agenda Performance Tuning Questions and Answers

  4. GSI, INC. • GSI: International Organization Focused on JDE Clients & Services • Experience • 750+ years of core JDE Experience • All consultants have 10+ years of experience, average is 15 • 25+ year relationship with Oracle’s JD Edwards Team Technologies • Red Stack / Blue Stack / Purple Stack • WebSphere / Oracle Application Server / WebLogic / Fusion Middleware • Terminal Server / Citrix / VMware / Oracle VM • XPI / webMethods / Web Services Gateway / Business Services Server XML & BI Publisher • Service Specialties • Upgrades, Assessments, Implementations (local , regional, and global)…100+ • World to E1 Upgrades and Stack Migrations… 40+ • Managed Services, Remote DBA Services, Tech Admin Services, Field Consulting, Remote Application Services • JD Edwards Performance Optimization • JD Edwards Load Balancing, Archiving, High Availability & Hosting • Confident enough to have a 100% Guarantee on all services

  5. Why? Are we concerned about something? End user performance or additional users? Do we have the skills to fix the problems? Performance Testing Lifecycle Specify Critical Processes Tune/Optimize Measure Observe Trends Measure and Track Performance (How Many/How Fast) Response times experienced by users Number of transactions per hour Batch processing times by job or group of jobs Number or size of XML documents via web services How many users does the system support DEFINING PERFORMANCE

  6. Effects of Changing Equipment Effects of Applying ESU’s & ASU’s Effects of Adding a New Business Unit New Tools or Application Release Data Growth Tales from the Performance Lab, Doc ID 978813.1 PERFORMANCE FACTORS

  7. Performance Workbench – JDE Tool JDE.INI Changes JAS.INI and JDBJ.INI UBE Introspection Separate BSFN Server and UBE Server Open Connections Changes in IE (“Spinning Wheel”) Code Currency (performance and memory ESU’s) Tools Updates Always verify MTRs E1 PERFORMANCE RECOMENDATIONS

  8. WebLogic Server JVM JDK Jrocket Tips for JD Edwards EnterpriseOne, Doc ID 1199775.1 WebSphere Application Server JVM Min/Max 64/1024 Browsers IE/Chrome/Firefox/Safari WEB SERVER CHANGES

  9. Firewall ACL Separate OS and Data Drive Event Log Viewer WINDOWS

  10. Firewall Setup Separate Mount Points for OS and Data Drive Shared Memory, Message Queues, Semaphores UNIX Kernel Parameter Recommendations for EnterpriseOne Doc ID 642497.1 UNIX/LINUX

  11. OS Troubleshooting Tips for iSeries Performance Issues, Doc IS 1314370.1 Tuning Memory Pools & QAQQINI and sqlServerMode SQL Packages. Doc ID 1525639.1 Performance Tuning on System i for JD Edwards (this was done in WebEx)https://oracleaw.webex.com/oracleaw/ldr.php?AT=pb&SP=MC&rID=57673212&rKey=dd4a2cefd249aba9 Other available iSeries Webcasts are as follows from Archived Advisor Webcast Recordings are available in Document 740964.1 JD Edwards EnterpriseOne and System i: Journaling, SQL Pkgs, and SQL Server JD Edwards EnterpriseOne and System i: Server Manager Agents on System i ISERIES

  12. Tempdb Logs Data & Index Files Direct ODBC Access Tips for Running EnterpriseOne with SQL Server 2008, Doc ID 843297.1 SQL SERVER

  13. Archive Logs Data & Index Files Redo logs Oracle Update Statistics Direct ODBC Access XML Issue- Oracle Databases Only: The DBA must run statistics over the package tables (F9867xx<package name>; ex. F98761PKGA) after Package Build finishes building them and prior to deploying the package. If this step is not done, processes that do significant spec accesses, such as On-Demand Generation, will be very slow. JD Edwards EnterpriseOne Oracle 11G Database Performance Red Paper, Doc ID 949948.1 JD Edwards EnterpriseOne Oracle 11G Database RAC Failover And Multi-Node Performance, Doc ID 956333.1 ORACLE DATABASE

  14. Latency & Bandwidth Jumbo Frames Packet prioritization and QOS (Packeteer, Bluecoat, Cisco, etc.) SAN Connectivity TCPIPTweaking.pdf LAN/WAN ISSUES

  15. EnterpriseOne Kernels White Paper JD Edwards EnterpriseOne Performance Tuning Suggestions for IBM WebSphere Application Server 7 EnterpriseOne UBE Performance and Tuning JD Edwards EnterpriseOne System Performance – Summit 2013 Platform Configuration Considerations for XML Metadata with JD Edwards EnterpriseOne IBM Power Systems with IBMi Performance and Tuning Tips for Oracle’s JD Edwards EnterpriseOne 9.0 Oracle JD Edwards EnterpriseOne WebLogic Performance and Tuning White Paper http://www.mcpressonline.com/database/db2/get-your-system-humming-7-great-tips-for-tuning-db2-for-i.html KEY SUPPORT DOCUMENTS

  16. General Information on EnterpriseOne Performance, Doc ID 636986.1 JD Edwards EnterpriseOne Performance Library, Doc ID 978813,1 JD Edwards EnterpriseOne Current MRT Index, Doc ID 747323.1, See Certifications Tab for 9.1.x and higher. EnterpriseOne Performance Workbench, Doc ID 747328.1 JDE.INI Tuning & Recommended JDE.INI Settings, Doc ID: 654975.1 Performance in JD Edwards EnterpriseOne, Doc ID: 1401813.2 Performance and Tuning: UBE Performance and Tuning, Doc ID 748333.1 EnterpriseOne UBE Performance Tips, Doc ID 825373.1 Performance Tuning for Oracle WebLogic Server, Doc ID 1505666.1 WAS: Performance Tuning Suggestions for IBM WebSphere Application Server Versions 6.1, 7.0 and 8.5 on EnterpriseOne HTML Server, Doc ID 1192485.1 Master Note for Troubleshooting JDE Related Issues at Operating System Level For All Platforms, Doc ID 1198723.1 KEY SUPPORT DOCUMENTS

  17. What can we do to help? GSI’S ASSISTANCE

  18. Technology Solution Assessment GSI’S S ASSISTANCE

  19. Pinnacle Performance Practice The Pinnacle Performance Practice (P3) was created to provide a peace of mind that your business system can handle your business now and in the future Simulate “real world” use with scripts Create scripts for each business process Inject scripts based on user counts and process mix (eg: 40% Dist, 20% Mfg, 10% inquiry) Identify bottlenecks and Lead to Performance Optimization Recommendations Find the “breaking point” Document peak performance and create a baseline. GSI’S ASSISTANCE • Can also be used to measure effects of: • Adding a business process, new users, or acquisition • Changes to Hardware, OS or DBMS • Changes to Software/Updates/Upgrades/INI files • Security Changes • Browser Upgrades or changes (IE, Firefox, Chrome & Safari)

  20. Tom Gabriele Director of Delivery Global Systems Integration, Inc.

  21. “…It takes FOREVER to run!” “…It doesn’t work…it is STILL processing!” “…It’s like watching paint dry!” USER COMPLAINTS

  22. Process Review Log Analysis Data/Code review Debugger TYPICAL TROUBLESHOOTING

  23. Make troubleshooting easier Discover slow running processes Discover problems not visible in debugger Optimize current processes Rate efficiency between alternate methods WHY TRY BENCHMARKING

  24. Gauge overall performance Identify the most time-consuming tasks or events Find the most efficient method Easily identify the area that may need optimization Uncover possible problems which lead to slow running jobs BENEFITS OF BENCHMARKING

  25. Basic Benchmarking Advanced Benchmarking BENCHMARKING METHODS

  26. BASIC BENCHMARKING Start of UBE End of UBE A~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Start Time HH:MM:SS End Time HH:MM:SS Total Runtime HH:MM:SS

  27. Pros: Provides overall program performance statistics Easy to create and implement Cons: Provides only the overall program performance statistics Difficult to identify which section or events within a section are the most time consuming BASIC BENCHMARKING

  28. Basic Benchmarking Advanced Benchmarking BENCHMARKING METHODS

  29. ADVANCED BENCHMARKING Start of UBE A~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ End of UBE Tasks Output Start Time HH:MM:SS Task 1 HH:MM:SS Task 2 HH:MM:SS … Total Runtime HH:MM:SS End Time HH:MM:SS

  30. ADVANCED BENCHMARKING Task A A Task B B Runtime Task C C Task A A

  31. Pros: Provides overall program performance statistics at the program level as well as at the section level Easy to identify which section or event within a section is the most time consuming Cons: More questions and scenarios to consider More effort to develop and implement ADVANCED BENCHMARKING

  32. BASIC VS. ADVANCED BENCHMARKING

  33. GSI’s BENCHMARKING UTILITY

  34. Please fill-out session evaluation Session ID: 100520

  35. Questions And Answers

  36. April 7-11, 2014 The Venetian and Sands Expo Center Las Vegas, Nevada QuestDirect.org/COLLABORATE Attend COLLABORATE 14 to hear high-level, strategic education for the JD Edwards audience. Register through Quest to receive exclusive JD Edwards updates, materials and networking events. Registration OPEN! Early Bird rates end February 12, 2014.

More Related