3

SAP CPQ – Guide to eliminate Common Performance Issues

 1 year ago
source link: https://blogs.sap.com/2023/03/07/sap-cpq-guide-to-eliminate-common-performance-issues/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
March 7, 2023 2 minute read

SAP CPQ – Guide to eliminate Common Performance Issues

Hi All,

This guide provides comprehensive advice on how to eliminate common performance issues seen in your CPQ applications. It covers everything from understanding the common performance issues and determining the root cause, to implementing the necessary changes to improve performance and prevent future issues.

It also provides overview and some best practices to help you diagnose, troubleshoot, and resolve any performance issues that may arise. Additionally, this blog provides suggestions on how to monitor app performance, identify and address areas of improvement, and establish an efficient performance management system. With this blog, you can be sure to optimize your application performance and ensure a flawless Sales user experience.

FccX_dtWQAoSBM2.jpg

8 Tips & Tricks to solve Performance Issues

1. Check system resources and configurations: Check the system resources (CPU, memory, disk, etc.) to ensure that they are configured correctly and are sufficient for the application.

2. Monitor for bottlenecks: Monitor for performance bottlenecks, such as disk bottlenecks, network latency, memory contention, etc., and take corrective action.

3. Optimize code and queries: Optimize the code and sql queries to ensure that they are as efficient as possible.

4. Utilize caching: Utilize caching to store frequently–accessed data and reduce the load on the database.

5. Utilize appropriate indexes: Utilize appropriate indexes to improve sql query performance.

6. Monitor application logs: Monitor application logs to identify and resolve issues quickly.

7. Tune SQL queries: Tune SQL queries to ensure that they are as efficient as possible.

8. Utilize a Developer Console: Utilize a console to Trace & identify code that is inefficient and can be optimized.

Main Dashboard
for to find Script Performance, System Errors, Storage, Users License.

2023-03-07_22-03-22.png
Script Performance to check if your scripts are running for long duration to optimize better.
2023-03-07_22-03-46.png
Developer Console for Tracing, Debugging and Performance tracking
2023-03-07_22-06-36.png

Areas to look at it for finding the Issues

  • Storage Space
  • Poor writing IronPython scripts
  • Scripts running for a long time
  • Custom table storing a huge data volume
  • Incorrect Html/Javascript coding in Responsive templates
FODGXacXMAEnTb0.jpg

API Response

  • Get the size of requests and responses (If you are working on API requests to get the data from applications).
  • Never pull huge volume of data from your custom API, recommend to have pagination concept.

Custom Table

  • Count the number of records into the database (you do not need to verify into all the tables, verify only the tables related to the service with the problem).
  • Check if the table has indexed
  • How long time take your service to finish when there are several users is accessble.

At this point, you should have all the enough information about what is happening, how it is happening, and where is it happening. Now, you have a general vision and you are ready to start to think about how to solve the problem in your application after reading this blog 🙂


About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK