Epicor 9.05

Performance

Monitoring

An ongoing process of performance

improvement

WHITE PAPER

Epicor Performance Monitoring i

WHITE PAPER

Table of Contents Executive Summary 1

Introduction 2

Epicor ICE Framework 2

ICE 2.0/Epicor 9.04 2

ICE 2.5/Epicor 9.05 3

Test System 3

Performance Results 5

Performance test notes 7

Conclusion 7

About Epicor 1

Epicor Performance Monitoring 1

WHITE PAPER

Executive Summary

Business today is fast paced, highly competitive, and more

demanding than ever before. In order to remain competitive,

applications and framework must evolve to reflect ever-changing

trends and demands. At the same time, new features and analytics

should not have a detrimental impact on existing forms and

processes.

This document

describes an

ongoing effort to

monitor

performance

improvements

made across the

framework and

applications for

the Epicor 9.05

version. It

compares the

performance of

Epicor 9.05

against the Epicor

9 and Vantage

8.03 versions.

As new

functionality is

added to Epicor

9.05, Epicor

pursues a continuous performance process to ensure that as the

product functionality becomes richer, performance is consistent or

improved. One key test compares the performance of complex

business objects between versions. High usage forms such as Sales

Order Entry, Opportunity/Quote Entry, Job Entry, and so on are also

tested after each application build to measure the impact of

framework and application changes on performance.

As this chart illustrates, performance continues to improve. Notice

how the response time for these high usage forms significantly

decreases with each major release.

Epicor Performance Monitoring 2

WHITE PAPER

Introduction

This white paper provides a look at how Epicor measures

performance over each application and framework build to ensure

additions to Epicor components and capabilities maintain or

improve the performance of the application.

Epicor ICE Framework

The core foundation for Epicor enterprise applications is its unique

business architecture, Internet Component Environment (ICE).

Epicor ICE 2.0/2.5 leverages the capabilities of Microsoft Windows

Server, Microsoft SQL Server, and Microsoft Visual Studio, fusing

them with Web 2.0 and Enterprise SOA concepts. This framework

design delivers rich and productive user experiences that support

agile business processes.

The Epicor ICE 2.0/2.5 framework is a robust combination of

adaptable SOA with Business Process Management (BPM),

workflow orchestration, dynamic embedded personalization, and

productivity tools. This combination provides a rich, collaborative

enterprise experience which can be extended to meet the

changing needs of businesses today and help businesses anticipate

and adapt to the needs of tomorrow.

Epicor 9.04 was delivered with the ICE 2.0 framework and Epicor

9.05 was delivered with ICE 2.5 framework. Many enhancements

were made to the ICE platform during each release. Both efficient

feature performance and improved framework performance were

emphasized during the development process.

The following enhancements were delivered as a part of these

performance improvements.

ICE 2.0/Epicor 9.04

Application Built Dashboards. By generating an Epicor form

through the Dashboard Designer, all custom designed

dashboards load faster.

Epicor Performance Monitoring 3

WHITE PAPER

Language Translations. Translations are handled in

Microsoft/.NET Resource files, ensuring that load

performance is the same for all language files.

Improved UI Caching. By extending caching functionality to

combo boxes and other user interface (UI) controls, form

load and general client performance improves.

Tree Display. Large numbers of tree nodes previously slowed

display time. The interface now defaults to 200 nodes, and

this value can be modified through a configuration setting.

Splash Screen. Timing on the splash screen is adjusted to

appear earlier and load faster.

ICE 2.5/Epicor 9.05

WAN Compression. A User account option causes data

compression to occur from server to client; the

improvement results in a 70% reduction in network traffic.

Significant performance improvement for WAN users.

Direct Service Calls from Service Connect. Through Service

Connect, client DLLs for service method calls can be used

instead of Epicor Web Services. These direct calls preserve

the login session throughout the workflow, resulting in

significant performance gain.

Updatable Dashboards. As data is entered through

updatable dashboards, this feature supports multi-threading

for increased performance.

On-Demand Client deployment. Client installations only

install required client DLLs, ensuring minimal installation time.

Replication trigger tuning.

Replication triggers are tuned to avoid database reads

during a row update.

Improved UI Caching. Extended caching on toolbar

settings, attachment document types, and InfoZone BAQs

reduces roundtrips to the Application Server.

Improved SQL DB processing. Primarily used during searches,

the improved Server side processing of List datasets returns

data resultsches.

Test System

Performance metrics for all versions are measured against a

standard preconfigured system. This standard system ensures

extraneous variables remain constant for all tests. Automated tools

measure the response time of certain high usage forms; these

Epicor Performance Monitoring 4

WHITE PAPER

results are analyzed to identify the performance impact of a form

or a business process.

Test system Configuration:

Hardware

HP X5670,

Dual Core processor @ 2.93 GHz,

24 GB Ram

Operating System

Windows 2008 R2 Standard

Application Platform 32 bit

Database

SQL Server 2008 R2

Diagnostic Toolset Epicor 9 Performance Tool

Hard Drives Solid State

Customization None

BPM Method Directives Disabled

BPM Data Directives Disabled

Virtualized No

Server Configuration Application and SQL on the same Server

Note: The test system is configured on a single server with the Epicor

Application and SQL database on the same server. Only a single user is

active during these tests. The system is a small business configuration that

provides optimum performance for low numbers of users, but is not

scalable for larger systems that require separate SQL server databases and

multiple Application Servers. Results may change under different

configurations.

Epicor Performance Monitoring 5

WHITE PAPER

Performance Results

Performance results compare key business processes at Epicor 9.05

against the same processes at Vantage 8.03 and Epicor 9.04. The

first table highlights the percentage improvement in response time

for each release, using Vantage 8.03 as a baseline. Detailed test

notes are included after the table of results. The second table and

graph compare the load times for key forms over all three releases.

Percent Improvement over 8.03

Application Form Load Approach Epicor 9 .04 Epicor 9.05

Epicor 9.05.700

Quote Add 20 Lines to Quote 37.26% 52.55% 53.71%

Sales Order Add 20 Lines to Sales Order 16.92% 32.56% 35.51%

Purchase Order Add 20 Lines to Purchase Order 19.59% 31.55% 39.14%

Job Create Job and Get Detail 15.79% 34.04% 50.88%

AR Invoice Add 20 Lines to A/R Invoice 12.02% 15.58% 17.16%

GL Journal Add 20 lines to G/L Journal 53.25% 63.31% 63.73%

Performance Analysis Details

Application Form Load Approach Vantage 8.03

Epicor 9 .04

Epicor 9.05.607

Epicor 9.05.700

Quote Add 20 Lines to Quote 57.7 36.2 27.38 26.71

Sales Order Add 20 Lines to Sales Order 46.1 38.3 31.09 29.73

Purchase Order Add 20 Lines to Purchase Order 24.5 19.7 16.77 14.91

Job Create Job and Get Detail 5.7 4.8 3.76 2.8

AR Invoice Add 20 Lines to A/R Invoice 20.8 18.3 17.56 17.23

GL Journal Add 20 lines to G/L Journal 16.9 7.9 6.2 6.13

Epicor Performance Monitoring 6

WHITE PAPER

37.26%

16.92%

19.59%

15.79%

12.02%

53.25%

53.71%

35.51%

39.14%

50.88%

17.16%

63.73%

0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00%

Quote

Sales Order

Purchase Order

Job

AR Invoice

GL Journal

Performance Improvement Over Vantage 8.03

Epicor 9.05.700 Epicor 9 .04

0

10

20

30

40

50

60

Quote Sales Order Purchase Order Job AR Invoice GL Journal

Vantage 8.03 Epicor 9 .04 Epicor 9.05.607 Epicor 9.05.700

Epicor Performance Monitoring 7

WHITE PAPER

Performance test notes

1. Vantage 8.03.409, Epicor 9.04.506, Epicor 9.05.607 and

Epicor 9.05.700 versions were tested.

2. All timings are displayed in seconds.

3. Timings are captured using the Client Trace Log thus reflecting observed experience for the user.

4. All tests are conducted against the delivered Training

database

5. All 20 line tests are conducted via Paste Insert of lines to a new record (Quote, Sales Order, Purchase Order etc).

6. The Create Job and Get Detail test includes a summary of the client execution times for all methods called during this

process.

Conclusion

As more features and content are added to the ICE framework and

the Epicor application, improved performance is a high priority.

Ongoing focus on performance measurement and analysis helps

ensure the user experience improves with each release.

About Epicor

For over 20 years, Epicor has been a recognized leader dedicated

to providing leading edge enterprise software solutions to

midmarket companies around the world. With over 20,000

customers, Epicor delivers end-to-end, industry-specific solutions that

enable companies to immediately improve business operations and

build competitive advantage in todays real-time global economy. Epicors comprehensive suite of integrated software solutions for Customer Relationship Management, Financials, Manufacturing,

Supply Chain Management, and Services Execution and Control

provide the scalability and flexibility to support long-term growth.

Epicors solutions are complemented by a full range of services, providing a single point of accountability to promote rapid return on

investment and low total cost of ownership.

Disclaimer

2012 Epicor Software Corporation. Epicor and the Epicor logo are

registered trademarks of Epicor Software Corporation. All other

trademarks acknowledged. All rights reserved. Published in the

U.S.A, 06/12. This document is for informational purposes only and is

subject to change without notice. Actual times may vary.

Performance tests are conducted on a preconfigured test

environment; actual times on a customer's production environment

may differ from the results in this document due to variances

between the customer's environment, loads, and test processes.

Epicor makes no warranties, express or implied by this document

and expressly disclaims the implied warranties of merchantability

and fitness for a particular purpose. The contents of this document

are believed to be current and accurate as of its date of

publication. For a complete description of the product features,

please refer to the products user guides, reference manuals and release notes. Usage of Epicor Software products is subject to the

terms of Epicors written end user license agreement.

For more information, contact Epicor Software Corporation: info@epicor.com

Worldwide Headquarters

4120 Dublin Blvd

Dublin, CA 94568

USA

Phone 888-448-2636

www.epicor.com