PDF now
Contents
1. lt New gt Figure 3 Edit jetty xml 3 Increase the value of maxThreads as per your requirement 4 Save this file 5 Restart the Kernel and WebRunner Adeptia Suite Performance Tuning Guide Adeptia Incorporation Best Practices BEST PRACTICES e f Data Mapper needs to process large file more than 50 MB then always use splitting inside Data Mapper activity You can enable splitting in Advanced Properties of Data Mapper activity and set Splitter Merger x path inside Data Mapper Applet For more details on how to apply splitting in Data Mapper please refer to Adeptia User manual e Always try to implement database caching inside Data Mapper This can be achieved by making a DBQuery at Root node storing the results in global variable and then for each record in input using the global variable value to get the results from database It would reduce the number of database interactions probably one for whole Data Mapping and hence optimizing the performance of Data Mapper e There may be a need to increase the Operating System configuration for maximum allowed open file handles Please check the help for your OS to see how to increase this parameter e If large number of concurrent process flows are executing in Adeptia Server then make sure that number of concurrent connections to backend and log database are set to appropriate values You can configure this in etc server configure properties file Here are the properties2. Goto Setup and then click Application Settings 3 Expand System and then Logging A Property Name log4j rootLogger Value fERROR console jdbc Description System and ProcessFlow Logging Level Note To activate this property after any change you need to Restart Server Property Name log4j logger Event Value Description Events Logging Level Note To activate this property after any change you need to Restart Server Property Name log4j logger com mchange Value ERROR Description c3p0 Logging Level Note To activate this property after any change you need to Restart Server 4 Change the values of the properties as shown above 5 Save the configuration and restart Kernel and WebRunner 12 Adeptia Suite Performance Tuning Guide Adeptia Incorporation Process Flow Settings PROCESS FLOW SETTINGS e To reduce the log generation Keep Log level for process flow as Error e To make sure that the disc space is not filled up use Delete on success option for repository cleanup e To delete the activities logs to keep Activities Logging Retention as Delete on Success This will further reduce the amount of log generated You can configure this as follows 1 On the Process Flow Manage page select the radio button adjacent to process flow and click Edit link see Figure 1 Process Flow JH_SCHWACKE_AS24CSV 4 Standard Properties Name fina Schwacke to AS24CSV PF Descrip
3. change connection pool size of log database open Server Configure properties file from lt AdeptiaSuitelnstallFolder gt ServerKernel etc folder and change the value highlighted in figure below lt Group name Log Database Connection Pooling gt lt Property comment Enable pooling for Log Database dynamic no name abpm logdb pool enable gt yes lt Property gt lt Property comment The maximum number of active connections that can be allocated from this poo lt Property comment The maximum number of connections that can remain idle in the pool without dynamic no name abpm logdb pool maxIdle gt 10 lt Property gt lt Property conment The minimum number of connections that can remain idle in the pool without dynamic no name abpm logdb pool minIdle gt 10 lt Property gt lt Property conment The maximum number of milliseconds that the pool will wait when there are n dynamic no name abpm logdb pool maxWait gt 1 lt Property gt lt Property conment TThe initial number of connections that are created when the pool is started dynamic no name abpm logdb pool initialSize gt 10 lt Property gt BACKEND DATABASE CONNECTION POOL Following property can be configured to control the size of backend database connection pool It is set to 50 but can be increased if Log connections are not available To change connection pool size of backend edit the Server Configure Properties file and change th
4. database and processing in Adeptia e Using Database loader programs for faster loading of bulk data into databases rather than using Adeptia JDBC connectors Adeptia Incorporation Adeptia Suite Performance Tuning Guide 15 Additional Tuning Options For Large Volume Data ADDITIONAL TUNING OPTIONS FOR LARGE VOLUME DATA Configure larger Kernel Memory Use High speed multi core processors Mapping use splitting and Parallel processing in Mapping To know how to apply splitting refer to Using Data Mapper gt Splitting Source Data Section of Adeptia Suite Developer Guide DB lookups use same connection rather than new connection per record DB lookups implement database caching inside Data Mapper XML lookups use for better performance compared to DB lookups by pre fetching database records into XML and then doing XML lookups Schema Skip non required field in source schema Solution design Split the data and do parallel processing within process Maintenance Enable Frequent cleanup of logs amp repository 16 Adeptia Suite Performance Tuning Guide Adeptia Incorporation Additional Tuning Options For Large Number of Transactions Faster Response Time ADDITIONAL TUNING OPTIONS FOR LARGE NUMBER OF TRANSACTIONS FASTER RESPONSE TIME e Configure larger Kernel Memory e Configure Database connection Pool e Configure Queue Processor e Configure Clustering e Reduce number of discrete steps in flow by using cust
5. etc launcher properties file Webrunner JVM parameters WB JVM Xms1l28M Xmx512M Xrs XX PermSize 64M XX MaxPermSize 128M To reduce the number of repositories inside Adeptia Server all the process flows shall be deployed with Repository File Retention as DELETE ON SUCCESS Inside Adeptia Server data and log clean up should be enabled and properly configured The retain time number of days for which data and logs would be retained shall be properly configured according to the requirement Please note that data clean up means cleaning of repository files only For data clean up retain time in days can be configured through Adeptia GUI at Administer gt Configure gt Application Settings gt Update System Properties Path to the property is Maintenance Data Cleanup Properties The name of the property is abpm appmanagement retainTime For log clean up retain time in days for different tables can be configured through etc log cleanup properties file Default value for retain time in days is 14 20 Adeptia Suite Performance Tuning Guide Adeptia Incorporation Table of Figures TABLE OF FIGURES Figure 1 Process Flow Configuration Page cccccsecceeceeeceseceseceeeceecaeeeeeeeeeseeeseeeseceaeceaeceaeceaesaeeeaeeseeseeeeeeeeeeseeeseaess 13 Figure 2 Process Flow Advanced Properties c cssccssccesscessceseceeecacecaeeeeeseceeeseenseeeceaeceaeceaecaaecaeecaeeeeeseneeeeeeenseeseeaees 14 Fi
6. that needs to be modified abpm jdo maxActive for backend database abpm logdb pool maxActive for log database You need to re start Adeptia Services after changing these properties e Running large number of concurrent process flows require more memory to be assigned to Adeptia Kernel You need to assign sufficient memory to Adeptia Kernel so that it can execute the process flows without any hassle To configure memory assigned to Adeptia Kernel you need to change following in etc launcher properties file Kernel JVM parameters KN JVM Xms512M Xmx1024M Xrs XX PermSize 64M XX MaxPermSize 128M Xms represents initial memory assigned to Adeptia Kernel at start up Xmx represents the maximum memory that can be assigned to Adeptia Kernel if available You need to re start Adeptia Services after making this change Adeptia Incorporation Adeptia Suite Performance Tuning Guide 19 Best Practices e To reduce logging on LIVE systems all the process flows shall be deployed with ERROR logging level e The number of objects and processes within the backend database governs the performance of the user interface Therefore when the backend database becomes large you may need to increase the memory setting to this database 1 Administer gt Setup gt Application Settings gt Update System Properties gt Embedded Database Settings 2 Increase the abpm embedded indigo memory value as well as the Adeptia WebRunner within
7. 30 30 30 Max Idle 50 50 50 50 100 Min Idle 20 20 20 20 40 Max Wait 60000 600 000 600 000 600 000 600 000 Archive cleanup cron 003 003 003 003 003 Data cleanup retain time 5 2 2 2 2 8 Adeptia Suite Performance Tuning Guide Adeptia Incorporation Configuration Settings for Production Environment Log cleanup retain time 5 2 2 2 2 Archive cleanup retain time 15 10 10 10 10 Web Server HTTP Port 8080 80 80 80 80 log4j rootLogger INFO console jdbc ERROR console jdbc log4j logger org exolab castor INFO ERROR ERROR ERROR ERROR log4j logger Event INFO ERROR ERROR ERROR ERROR Adeptia Incorporation Adeptia Suite Performance Tuning Guide 9 Java Heap Size JAVA HEAP SIZE Adeptia Suite uses different JVM instances for Kernel and WebRunner Following are the recommended Java heap size settings Operating System and Java JRE i 64 bit Java heap size for Kernel 60 of the total memory Java heap size for WebRunner 20 of the total memory For Example For 8GB RAM Kernel 4 8GB WebRunner 1 6GB For 16GB RAM Kernel 10GB WebRunner 3 2GB 10 Adeptia Suite Performance Tuning Guide Adeptia Incorporation DB Connection Pool DB CONNECTION POOL LOG DATABASE CONNECTION POOL Following property can be configured to control the size of Log database connection pool It is set to 100 but can be increased if Log connections are not available To
8. AX ADEPTIA Adeptia Suite 6 2 SP1 Performance Tuning Guide Release Date August 12 2015 Adeptia Inc 343 West Erie Suite 44 Fax 312 229 1736 Document Information DOCUMENT INFORMATION Adeptia Support Information For support queries please contact us at support adeptia com Access the Adeptia Web site at the following URL www adeptia com Copyright Copyright 2014 2015 Adeptia Inc All rights reserved Trademarks Adeptia is a trademark of Adeptia Inc All other trademarks and registered trademarks are the property of their respective owners Confidentiality CONFIDENTIAL AND PROPRIETARY INFORMATION OF Adeptia The information set forth herein represents the confidential and proprietary information of Adeptia Such information shall only be used for the express purpose authorized by Adeptia and shall not be published communicated disclosed or divulged to any person firm corporation or legal entity directly or indirectly or to any third person without the prior written consent of Adeptia Disclaimer Adeptia Inc provides this publication as is without warranty of any kind either express or implied In no event shall Adeptia be liable for any loss of profits loss of business loss of use or data interruption of business or for indirect special punitive incidental or consequential damages of any kind No part of this work covered by copyright herein may be reproduced in any form or by any means
9. an application s user interface A registry key Important information Indicates a reference or the title of a publication Indicates code examples or system messages Indicates system commands that you enter Indicates an Internet link to target material Adeptia Suite Performance Tuning Guide 5 Graphical conventions This guide uses the following graphical conventions Convention Description CONTACTS REPORTING PROBLEMS These sections present contact information for a variety of situations Sales In case of any sales queries please contact us at sales adeptia com Support For support queries please contact us at support adeptia com Latest updates and information For the latest updates and information please visit us at www adeptia com Adeptia Web site Access the Adeptia Web site at the following URL www adeptia com 6 Adeptia Suite Performance Tuning Guide Preface Adeptia Incorporation Recommended Settings RECOMMENDED SETTINGS To get the better performance it is recommended to use servers with the configuration given below e 4CPU cores minimum 2 quad core CPUs 8 cores recommended e Min 8GB 16GB recommended e OS 64 bit e Hard Drive 200GB minimum 500GB recommended e Log Database For higher performance Adeptia recommends a separate database for logs such as MS SQL Server Oracle or MySQL By default an embedded database is used which limits the performance For higher perfo
10. e value highlighted in figure below lt Category gt lt Category name Systems gt lt Group hide true name Database Configuration gt lt Property comment JDO Database Driver Url dynamic no name abpm jdo driver gt lt Property comment JDO Database Connection Url dynamic no name abpm jdo url gt jdbc hsqldb hsql 7 127 0 0 1 2476 lt Property gt lt Property comment JDO Database UserName dynamic no name abpm jdo username gt lt Property comment JDO Database Password dynamic no encrypt y name abpm jdo password gt lt Property comment JDO Mapping File dynamic no hide true name abpm jdo mapping file gt mapping xml lt Property gt lt Property comment JDO Database Name dynamic no name abpm jdo database name gt lt Property comment JDO Database Engine Name dynamic no name abpm jdo engine nam lt Property of active connections that can be allocated from th lt Property comment The maximum number of connections that can remain idle in the pool wi dynamic no _ name abpm jdo maxIdle gt 10 lt Property gt Adeptia Incorporation Adeptia Suite Performance Tuning Guide 11 Configure Logging Level CONFIGURE LOGGING LEVEL To achieve higher concurrency following logging levels should be set to ERROR e log4j rootLogger e log4j logger Event e log4j logger com mchange To configure these properties 1 Login as admin user go to Administer tab 2
11. graphic electronic or mechanical including photocopying recording taping or storage in an information retrieval system without prior written permission of the copyright owner This publication is subject to replacement by a later edition To determine if a later edition exists contact www adeptia com 2 Adeptia Suite Adeptia Incorporation Table of Contents TABLE OF CONTENTS Document Information 2 Table of Contents 3 Preface 4 Target Audience 4 Applies To 4 How is this guide organized 4 Conventions 5 Typographical conventions 5 Graphical conventions 6 Contacts Reporting problems 6 Sales 6 Support 6 Latest updates and information 6 Adeptia Web site 6 Recommended Settings 7 Configuration Settings for Production Environment 8 Java Heap Size 10 DB Connection Pool 11 Log Database Connection Pool 11 Backend Database Connection Pool 11 Configure Logging Level 12 Process Flow Settings 13 Process Flow Design 15 Additional Tuning Options For Large Volume Data 16 Additional Tuning Options For Large Number of Transactions Faster Response Time 17 To handle High number of Concurrent User and High Volume of Web Service call 18 Best Practices 19 Table of Figures 21 Adeptia Incorporation Adeptia Suite Performance Tuning Guide 3 Preface PREFACE The performance tuning guide is designed to help Adeptia users configure Adeptia Suite for maximum performance It also describes different parameters that can be tweaked t
12. gure S EA jetty XM ennaii as aaa eieiei ne e a aAa ed dnt avediedsodsebddssncevades 18 Adeptia Incorporation Adeptia Suite Performance Tuning Guide 21
13. o improve the performance in different scenarios Target Audience This document is intended for all the users who want to monitor and improve the performance of Adeptia Suite Applies To This document applies to the following Adeptia Products Adeptia EBIM Suite Adeptia BPM Suite Adeptia B2B Integration Suite Adeptia Integration Suite Adeptia ETL Suite HOW IS THIS GUIDE ORGANIZED This guide is organized into the following sections Section Description 4 Adeptia Suite Performance Tuning Guide Adeptia Incorporation Section Preface Description Additional Tuning Options For Large Volume Data Additional Tuning Options For Large Number Of Transactions Best Practices CONVENTIONS Configure larger Kernel Memory Use High speed multi core processors Mapping use splitting and Parallel processing in Mapping Faster Response Time Best Practices The following tables list the various conventions used in Adeptia documentation We follow these conventions to help you quickly and easily identify particular elements processes and names that occur frequently in documents Typographical conventions This guide uses the following typographical conventions Convention Description Bold text Italic text Monospaced text Monospaced bold text Hyperlink Adeptia Incorporation Indicates one of the following Screen element New terminology A file or folder name A control in
14. om plugins e Enable JDO Caching e Set correct logging level e Optimize TCP settings if you are using Windows OS To know how to deploy clustering refer the Deploying Clustering section of Adeptia Suite Developer Guide To know how to enable JDO caching refer the Enabling Caching section of Adeptia Suite Developer Guide To know how to set correct logging level refer the section Configure Logging Level If Adeptia Suite is installed on Windows operating system then you should also optimize TCP settings to avoid port exhaustion For detailed steps refer http msdn microsoft com en us library aa560610 v bts 20 aspx Adeptia Incorporation Adeptia Suite Performance Tuning Guide 17 To handle High number of Concurrent User and High Volume of Web Service call TO HANDLE HIGH NUMBER OF CONCURRENT USER AND HIGH VOLUME OF WEB SERVICE CALL To handle high number of concurrent user and high volume of Web Service call you need to increase jetty thread count Step to increase the jetty thread count 1 Goto lt Adeptia installation folder gt ServerKernel etc jetty 2 Open jetty xml file See figure below lt lt Server Thread Pool lt lt Set name ThreadPool gt lt Default queued blocking threadpool gt lt New class org eclipse jetty util thread QueuedThreadPool gt lt Set name minThreads gt 10 lt Set gt lt Set name maxThreads gt 200 lt Set gt lt Set name detailedDump gt false lt Set gt
15. rmance the log DB can be installed on a separate server Depending on the size of the data and performance needed servers with higher configuration can be used Adeptia Incorporation Adeptia Suite Performance Tuning Guide 7 Configuration Settings for Production Environment CONFIGURATION SETTINGS FOR PRODUCTION ENVIRONMENT The default configuration settings of Adeptia Suite are not recommended for production environment To use Adeptia Suite in Production Environment configure the following properties according to your Adeptia Suite Edition Table 1 Configuration Settings for Production Environment Property Name Default Values Express Professional Premier Enterprise Edition Edition Edition Edition Kernel Xms 512M 512M 2048M 2048M 5120M Kernel Xmx 1024M 1024M 4096M 4096M 8192M WebRunner Xms 256M 256M 256M 256M 512M WebRunner Xmx 512M 512M 512M 512M 1024M Backend DB Xmx 1024M 750M 1024M 1024M 1024M Log DB Xms 512M 512M 512M 512M 1024M Log DB Xmx 1024M 750M 1024M 1024M 2048M Queue Processor concurrent 5 5 10 10 20 processes Queue Processor reload 20 20 40 40 80 factor Backend DB Pool Size 50 50 50 50 100 Log DB Pool Size 100 100 100 100 200 Cluster DB Pool Size 25 25 25 25 50 Archive DB Pool Size 25 25 25 25 50 Max Idle 20 20 20 20 50 Min Idle 10 10 10 10 20 Max Wait 60000 600 000 600 000 600 000 600 000 Values for Log pools 30 30
16. tion Logging Level ERROR v Repository File Retention DONT DELETE v Process Flow Designer Advanced Properties Mandatory fields Figure 1 Process Flow Configuration Page 2 Select Error from the drop down list Logging Level 3 Select Delete on Success from the drop down list Repository File Retention Note This feature is available from Adeptia Suite Version 6 2 onward 4 Expand the Advanced Properties and select Delete on Success from the Activities Logging Retention drop down list see Figure 2 Adeptia Incorporation Adeptia Suite Performance Tuning Guide 13 Process Flow Settings 4 Advanced Properties Retain Process Variable Xml Recoverable Process Flow Activities Logging Retention DELETE ON SUCCESS v Priority NORMAL 7 Figure 2 Process Flow Advanced Properties 14 Adeptia Suite Performance Tuning Guide Adeptia Incorporation Process Flow Design PROCESS FLOW DESIGN The biggest factor in determining the performance of a process flow in Adeptia is how the flow itself is designed e Fewer activities steps in the flow result in more in memory processing which leads to faster performance e Anumber of steps in the flow which use Adeptia activities could be combined in a custom plugin for faster response time e Use database stored procedures queries joins for in database processing whenever that option is available rather than extracting large amount of data from the
Download Pdf Manuals
Related Search