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 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.

Note: The account should have SysAdmin or DB_Owner roles to execute sp_updatestats.

Schedule Database Maintenance

To configure scheduled maintenance,

Enable Maintenance Schedule using the Toggle Button.
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.

Memory Threshold - Monitors heap usage. If the memory space exceeds the configured value, a heap dump will be generated. Administrators can set the memory threshold value of JAVA in terms of percentage instead of MB. By default, the configured value is 95%.

Log File Size Threshold

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,

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