CHAPTeR 9 DXP PeRfORMANCe OPTIMIzATION Common Performance Problem Pattern In this section we discuss the common performance issues observed in DXP applications and their root causes. Following are some of the commonly encountered performance issues that we have seen in the past: • Performance issue: Applications not scalable. Some symptoms, with increase in load: • Response time increases drastically. • Some queuing is observed. • Gradual performance degradation with increase in user load • CPU utilization at some layer remains constant. • Common reasons: • Absence of caching framework that caches frequently used objects • Existence of single point of failures • Absence of clustered setup for web server, application server, and database server. A clustered setup involves multiple nodes/machines to serve the response providing failover and high availability. • Inappropriate business object tuning. If the business objects are not tuned for performance, it has ripple effect on the overall application’s performance. • Inappropriate infrastructure sizing such as CPU cores, memory, network bandwidth, and such. • Inappropriate connection pool settings such as maximum connections, minimum connections, connection idle time out, and such 252