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 ADSelfService Plus?

                    • Related Articles

                    • Steps for Performance Tuning

                      Supportcenter Plus performance can be improved by tuning the JAVA performance as said below : For version 8: 1. Shut down the application. 2. Navigate into \SupportCenter\server\default\conf 3. Edit the file -> wrapper.conf with administrator ...
                    • Basic Performance Issues RCA On Postgres DB Cx

                      Whenever cx faces slowness in PG SQL Setup, below are the first step of actions to check and proceed based on our previous performance tickets. 1. Antivirus are main cause of slowness, high CPU, and memory consumption of PGSQL in many cx tickets. ...
                    • 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| ...
                    • Inputs required for analyzing Performance Issues

                      We need a couple of details to analyze Performance issue. So, please send the below details : Below mentioned details should be gathered before restarting the application. 1. Let us know whether you are taking Scheduled full backup or backup without ...