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
