77 Posts
0
725
NetWorker - SQL logs to run while FULL/DIFF execute
Hi everyone,
I've been experimencing a strange behavior for a while now which goes as follow.
I have SQL logs backup which runs every 15 minutes. However, whenever the FULL or the DIFF runs, the SQL logs backups just wait for them to complete before completing the logs which causes several problem to customer environnement. In resume, if the FULL takes 6h, then the log workflow will wait 6h before running the following job, which is not right.
I know both can work together i've test it out with a LAB server and there is no problem at all. I've checked thorougly my configurations, and i don't see any differences.
NetWorker server version/OS is : 19.2.1.2 Built 118 / Linux (NVE)
If anyone would have an idea, it would be greatly appreciated.
Thank you,
Chris
crazyrov
4 Operator
4 Operator
•
1.3K Posts
0
June 9th, 2021 06:00
@CarC8, Have you tried increasing the parallelism on the SQL client ?
CarC8
77 Posts
0
June 10th, 2021 08:00
Crazyrov,
Thank you so much, that was precisely the problem.
Customer asked to reduce the number of concurrent streams a while ago on their Production SQL server. So the parallelism value was cut by 50% to a value of "2". The moment i got the value higher, it start working again.
Thank you and have a nice day ahead,
Chris