SAP HANA plugin performance due to Job definition and logs capture (4042872)

SAP HANA (backint) supports backup of multi tenant database, hence observed to record large information to Netvault (Netvault PostgreSQL is considerably impacted often resulted in performance issue

Resolution

1. Multiple jobs gets created as the user managed SAP HANA backup fills up the Manage Job Definition ,needs to be periodically purged.

Below is the CLI option to delete them

Please refer the Netvault CLI Guide option for syntax and parameters

• Delete jobs with the following Job ID numbers: 1, 5, range 7-12, range 15-19:

nvjobdelete -jobid 1 -jobid 5 -jobrange 7-12 -jobrange 15-19

• Delete all backup jobs that have the job name “Backup of Client-A” and job ID numbers between 70 and 100 

nvjobdelete -type backup -jobtitle “Backup of Client-A” -jobrange 70-100

• Delete all jobs for “Client-A” that use the Schedule Set “FirstTuesday”:

nvjobdelete -client Client-A -schedulesetname FirstTuesday -force

2. SAP HANA backup records too many log information to the Netvault database , which causes performance issues Enhancement request NV-I-762 is submitted to optimize logging.

Alternatively increasing these parameters have observed to be of use in improving Netvault performance

max_connections        400 can be increased to 600 and greater                   
shared_buffers           1GB based on the memory can be increased        

reference : https://www.postgresql.org/docs/10/runtime-config-resource.html