managing challenges in your jda environment

1Spinnaker Proprietary & Confidential 2015

All Rights Reserved

Spinnaker Proprietary & Confidential 2015

All Rights Reserved

1


All Rights Reserved 2

• Introductions

• Back to Basics: JDA SCM Solution Overview

• Common JDA Performance Challenges

• The Impact of Solution Maturity

• What If?

• Simple Techniques to Conquer Performance Challenges

• Advanced Approaches for Performance Improvement


All Rights Reserved

Speakers

Yannick Germain• Founder of Germain Software and high

technology professional with over 15

years of experience in software

development, systems performance,

and scalability engineering.

• Spent eight years at Siebel Systems,

three of which were spent developing

application modules for the Siebel Field

Service and Call Center product lines,

and the remaining five of which were

spent on performance and scalability

engineering projects for the core Siebel

Enterprise product lines.

Ken Poore• Supply chain professional with over 16

years of experience in systems design,

implementation, and performance

engineering working directly with

customers in a consulting capacity

through the full software cycle.

• Background as a technical lead,

technical developer, database

performance lead, support lead, and

project manager with supply chain

planning tools provides him with a

perspective uniquely suited to manage

cross-functional teams required to

deliver SCM solutions.



Back to Basics



• Multiple Tier Architecture– Allows for scalability

– Allows for disaster recovery

• Numerous Configuration Options– Web Server Tier

• Load Balancer

– Application Server Tier

• Oracle Weblogic, IBM Websphere

• Clustered and Non-Clustered

– Database Tier

• IO Configuration

– Algorithm Tier

– Network Tier

– Web Client Tier

JDA Architecture Overview

Web Access Tier

Load Balancer

Application Server 2


Application

Server Tier

Application Server

Administrative Node


Process

ExecutionJDAEAS Algorithm Tier

DataBaseOracle Database



• The JDA Application is often just one part of an ecosystem of planning and

execution systems

– ERP, TMS, BI, WMS, UPD, OTC

– Other Systems

• Performance problems and the need to monitor exists at every level

The Supply Chain System Ecosystem

JDAERPBI

Reporting

TMS

WMS



Clients that own JDA often experience a host of common performance related

challenges

• Maintaining Performance across various levels of complex, multi-tiered deployments

• Providing consistent performance for batch and online processes even when volumes

change over time

• Identifying the source of performance issues when they occur and providing a

mechanism to clearly identify and quantify performance expectations

• Creating a mechanism to determine when performance maintenance is warranted for

the continuous care and feeding of the system

• Creating a methodology to quantify results to determine when and where incremental

resources may be required.

Common JDA Performance Challenges



As the solution grows, quite often so

does solution complexity and

performance requirements

• New Modules

• New Solution Enhancements and

Customizations

• New Data Structures and Custom

Objects

– Increased Data Volumes

– Increased Planning Horizons

– Obsolete Data

• Increased User Counts

• New and Competing Processes

The Impact of Solution Maturity

Solution Growth

Com

ple

xity



There is no performance Panacea, but what if?

You had the power to determine the real performance of your JDA system?

You had the ability to identify performance bottlenecks before they caused major issues?

You had the foresight to know well in advance when additional hardware was needed?

You had the ability to generate meaningful performance metrics to drive maintenance,

cleanup and future expansion investments?

You had the ability to measure key business changes over time?



• Define a measurement infrastructure that extracts and maintains a history of

critical performance metrics

• Determine expected batch windows and performance expectations

• Understand the implications of the functional impact of technical processes

• Establish SLAs and maintenance processes to maintain optimal performance

• Optimize batch from the start: Archival and Maintenance, Imports, Exports,

Process Execution

• Include backup and recovery timeframes as a part of your performance design

Simple Techniques to Conquer

Performance Challenges

Design the Solution with Performance In Mind

Future Performance Requirements Should NEVER Be An Afterthought!



Gather the Right Performance Metrics



• Categorize custom tables

• Categorize custom scripts

– Business purpose

– Technical (maintenance, daily, monthly)

• Table sizes over time

• Table/report usage

• Number of users actively on system (cluster)

• Individual script performance

• Script errors over time



Analyze the Metrics

• Experts

• Tools (Spinnaker Scorecard)

Develop Task List

Rank Tasks

• Impact to business

• Implementation Duration

• Costs





Perform Routine Maintenance

• Daily– Invalid data during loads / processing

• Weekly– Script run time trends

– Monitor software vendor tickets

• Monthly– Script run time trends

– Log file analysis

– Log file removal and growth

• Quarterly– Online screen performance trends (base line updates)

– Data volume analysis (outliers)

– System support business goals analysis

– Software vendor patches

• Annually– Data volume analysis (holistic)





• Spinnaker leverages Germain Software’s APM Suite with the JDA

plug-in to perform comprehensive supply chain application

performance monitoring across components, jobs, and scripts.

– Dashboard for the collection and analysis of JDA related performance data.

– Platform to get ahead of performance trends long before they affect the

business

– Pinpoints source of JDA performance issues in real-time

• Develop Performance Profiles for Key Processes including:

– How much CPU and memory specific processes tend to take during

execution?

– Where and how the application tends to conduct much of its processing?

• Is it within the database or process server during batch?

• Is it in the application server, database, process server, or even on the client for

online use

Advanced Approaches for Performance

Improvement



• Five Main Components Make Up Dashboard

– Executive Dashboard

– Batch Summary Dashboard

– Technical Trending Dashboard

– Table Fragmentation and Sizing Dashboard

– Business Intelligence Dashboard

Germain Software’s APM Suite with

the JDA plug-in



• Designed for upper level management to view the metrics in an

aggregate manner to show how the system is performing on a

weekly, monthly, quarterly, and annual basis.

Executive Dashboard



• Provides a comprehensive look at all current and historical batch

run times to perform real time performance analysis or review

performance trends over time.

Batch Summary Dashboard



• Designed to show useful metrics and statistics based on the

performance of your custom batch processes. This dashboard can

be utilized for daily operations as well as snap shot reporting.

• Other Related Metrics

• Total DFUS counts

• Discontinued DFUS

• DFUs with no Hist, Fcst, DFUMap,

• DFUtoSKUMapValidation

• Total SKUs counts

• Inactive SKUS

• DFU Stagnation - Last Model Date

• Fcst Overrides by Product group

• Schedrcpts < ohpost




• Designed to show useful metrics and statistics based on the performance of your custom batch processes. This dashboard can be utilized for daily operations as well as snap shot reporting.

• Batch Analysis• Run time of base JDA jobs

• Run time of maintenance scripts

• Run time of custom scripts

• Daily start and finish performance against the SLA

• Daily Job Group SLA Performance

• Batch Snapshot to show percentage of job groups

• that comprise the batch

• Job Group runtime comparisons

• Top 10 Job Runtimes

• Percentage of job growth from one day to the next

• Batch Job Listing with runtimes




• Random performance of daily batch schedule solved

– Identified scripts with varying run times

– Identified scripts with sensitivity to data volume changes

– Addressed scripts with varying run times and sensitivity to data volume

changes

– Simplified the batch schedule

– Achieved stability and consistency

• Organizational Efficiency Improved

– Monitor system usage by planners

– Monitor overrides entered by brand

– Work collaboratively to build better business processes

– Adjust system to meet user needs

Performance Profiles



• 50+ pain points/performance issues impacting business

• Many integrated mission-critical apps (.Net, J2EE, SAP, Salesforce, Siebel CRM,…)

• Big Data, 50-150 Million real-time data points per day analyzed and

stored in Germain APM data mart, 6 TB Hadoop

• Many monitoring tools (homegrown, and packaged)

Results: Pepsi, Nestle, Dell (..) chose Germain APM as global APM/

Application Performance Management/Monitoring tool because:

• End-to-end performance monitoring, root-cause analysis

• Code Review, Configuration Audit and tuning Recommendations

• Correlation Engines

• Operational and Management Performance Dashboards

• Unlimited configuration (add any performance analytics, monitoring points within

minutes using Wizards, Rule Editor, etc.)

Application Use Case



Business Impact analysis

Transaction breakdown Audit/Security

Code Analysis

SQL<-> Transaction Lookup

Transaction Tracking

Automated

ActionsEmail alerts

User Experience Monitoring (from Browser)

360 Degree View


All Rights Reserved

Thank you!

Yannick Germain• [email protected]

• 415-946-4048

Ken Poore• [email protected]

• 504-460-6751

For Inquiries• Grant Goldberg

• Business Development Manager

• [email protected]

• 480-626-2728

23

mailto:[email protected]

