Performance Settings

Performance Settings

Performance settings allow you to configure various settings to improve the performance and stability of the application. You can configure Database related settings under General tab and report related settings under Reports tab.


General Settings

In this section, you can configure various database-related settings to improve the stability and performance of the application such as Schedule database maintenance and configure disk usage threshold to optimize the performance of ServiceDesk Plus.

 

Database Maintenance Schedule

 

The query optimizer uses table statistics to create query plans. To ensure optimal performance of query plans, the table statistics must be updated regularly. This database maintenance activity is carried out differently in different database systems. In the case of Postgres, the operation "VACUUM ANALYZE" is used and in the case of MS SQL, the operation "sp_updatestats" is used.  

 

Schedule database maintenance


To configure scheduled maintenance: 

    1. Enable Maintenance Schedule using the Toggle Button.

    2. Select a preferred Frequency and set a Starting Date, along with a preferred time. To avoid performance issues, schedule maintenance during non-operational hours.

Threshold

 

Monitoring disk usage is essential to prevent application failure or downtime. To do this, configure thresholds to send an email notification to Admin users.  

 

Disk Usage Threshold - Over time, the disk usage increases and eventually all available disk space will be consumed causing application failure. To prevent this, you can configure disk utilization threshold to trigger notifications to admin users. 

  • To set the disk utilization threshold, enter a preferred value in percentage in Disk Space field. 

MS SQL server maintains a transaction log file (.LDF) to record all transactions. This file could grow large and fill up the disk if left unmonitored and cause application downtime. To prevent this, an additional option is enabled for MS SQL users to configure log file size threshold that triggers an email notification to users.

  • To set the log file size threshold, enter a preferred file size in MB in Database Log File Size field.

 

 

Reports Settings


To optimize stability: 

    1. Modify limits on various report generation criteria such as row limits, the maximum number of simultaneous users, and report generation timeouts.

    2. Finally, click Save.

 


    • Related Articles

    • Outgoing Mail Server Settings

      Configure your organization's mail server to send emails. Outgoing mail server settings must be configured to trigger email notifications for the following settings. Two-Factor Authentication Backup Scheduling Security Settings Performance Settings ...

    • Application Settings and Self-Service Portal Settings

      Portal-specific Customizations and Configurations The following are the various portal-specific customizations and configurations. You can access these under Admin>>General Settings>>Self-Service Portal Settings in both single portal and multi-portal ...

    • attachment-settings

      Attachment Settings Attachment settings allow you to manage the files that users add as attachments in various modules. Role Required: SDAdmin. Go to Admin > General Settings > Attachment Settings and configure the fields as explained below: Fields ...

    • Proxy Settings

      You can configure a proxy server to add an extra layer of protection to the server that runs SupportCenter Plus.  This is an application-wide configuration. To configure a proxy server:  1. Go to Admin>>General Settings>>Proxy Settings (if only one ...

    • Performance Tuning Guide

       This guide provides a set of SQL queries and tips that improve the performance of ManageEngine SupportCenter Plus.  Restart the application after executing the queries. The list of performance tips discussed in this guide are: Java Tuning Enabling ...