NetWorker

Last reply by 06-10-2021 Solved
Start a Discussion
3 Silver
441

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

Labels (4)
Solution (1)

Accepted Solutions
4 Beryllium
428

@CarC8, Have you tried increasing the parallelism on the SQL client ?

HTH,
For NetWorker related content - https://www.youtube.com/channel/UC4JLsVyXMyjbQ4i1NaJj5IQ

View solution in original post

Replies (2)
4 Beryllium
429

@CarC8, Have you tried increasing the parallelism on the SQL client ?

HTH,
For NetWorker related content - https://www.youtube.com/channel/UC4JLsVyXMyjbQ4i1NaJj5IQ

419

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

Latest Solutions
Top Contributor