Java and PGSQL Tuning for better performance of the application

Java and PGSQL Tuning for better performance of the application

This article is common for ServiceDesk Plus MSP and Supportcenter Plus applications.

Application performance is based on multiple factors. To gain better performance, we need to tune JAVA / PGSQL.

For ticket inflow high environment and more users concurrent logins, we recommend to use MSSQL as database.

Java Tuning helps in boosting the performance of the application. Java heap has to be configured as per the RAM configured for the server and the available RAM. This article is applicable for versions 10.5 and above. 

Before proceeding to the config, please ensure if the MSP instance you are using is a 64 bit installation. You can verify this from the file
sdpArchitecture.xml under \ManageEngine\ServiceDeskPlus-MSP\conf.
 
For 64 bit OS , with 16 GB RAM , please follow the below : (In case you are using MSSQL as DB))

 Navigate to ManageEngine\ServiceDeskPlus-MSP\conf, edit the file named wrapper.conf in a WordPad or a Notepad++ and search for the keyword ‘heap’.
 
Now please do the changes as follows: (note that the size has to be mentioned in MB). Let the initial Java Heap Size be 1024 (1GB) and maximum i have set it to 12 GB based on the 16 GB RAM. You may change it as per the RAM allocated to the server but mention it in MB.

Initial Java Heap Size (in MB)
wrapper.java.initmemory=1024
Maximum Java Heap Size (in MB)
wrapper.java.maxmemory=12288

Once the changes are saved, Shut down and Start the ServiceDeskPlus-MSP service for this configuration to take effect.

NOTE: These changes are effective only if the application is started through desktop icon/Windows service and not applicable for application through command window.

In case you are using PGSQL as Database : We recommend the following :

2) And tune the JAVA , (use the above file mentioned) and tune it to 6 GB . ie you can go upto -> 5120 or 4096 (ie wrapper.java.maxmemory=5120)

If you need any clarifications or if you still face any performance issues, please drop an email to support@servicedeskplusmsp.com.
                  New to ADManager Plus?

                    New to ADSelfService Plus?

                      • Related Articles

                      • How to address Performance issue ?

                        Application will face the performance issue because of couple of reasons. 1. System requirements are not met: Refer this link to ensure the specifications are met as per the standards. 2. Application architecture should be 64-bit for better ...
                      • Unable to start the application due to Pgsql privilege issue

                        ISSUE: Application does not start via both services and command prompt. ERROR TRACE: Serverout: [16:26:36:443]|[05-10-2023]|[com.adventnet.db.adapter.postgres.PostgresDBAdapter]|[SEVERE]|[27]: Exception occurred while obtaining mode of the database| ...
                      • How to enable Performance monitoring tool ?

                        To analyze Performance issues, logs and tuning alone won't be sufficient. Hence, we need to follow a few steps to enable the Performance Monitoring tool, which will monitor the application's performance and automatically collects the data when the ...
                      • Performance Debug

                        For Performance/slowness issues instead of taking Threaddump manually or instead of invoking PerformanceTool make use of the below URL when the issue occurs, http://servername:portnumber/servlet/PerformanceDebug The above URL works even when the ...
                      • Application startup issue due to mismatch in java

                        A startup issue after the upgrade to the version 14.3 Error message: "Application startup halted due to mismatch in java". Issue: After a JRE upgrade, typically, if the "jre_old" folder exists, it will be deleted. Then, the "jre" folder will be ...