Using Arcserve UDP Agent (Linux) › How to Manage the Backup Server Settings › Improve the Query Performance for Job History and Activity Log

Improve the Query Performance for Job History and Activity Log

If you have a larger database file, then querying Job History and Activity Log takes a lot of time. You can improve the query time for Job History and Activity Log using specific switches and get your output in a short time.

Follow these steps:

1. Log into the Backup Server as a root user.
2. Open the server.cfg file:

   /opt/Arcserve/d2dserver/configfiles/server.cfg
   

   Note: If the file is not present, create the server.cfg file.

3. Add the following lines in the server.cfg file:
   • To improve Job History query performance, add the following line:

     skip_getting_job_history_count=true
     

   • To improve Activity Log query performance, add the following line:

     skip_getting_activity_log_count=true
     

4. Save the server.cfg file.

The query time for Job History and Activity Log has been successfully improved.