CarC8
3 Silver

NetWorker - SQL logs to run while FULL/DIFF execute

Jump to solution

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)
0 Kudos
1 Solution

Accepted Solutions
crazyrov
4 Beryllium

Re: NetWorker - SQL logs to run while FULL/DIFF execute

Jump to solution

@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

0 Kudos
2 Replies
crazyrov
4 Beryllium

Re: NetWorker - SQL logs to run while FULL/DIFF execute

Jump to solution

@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

0 Kudos
CarC8
3 Silver

Re: NetWorker - SQL logs to run while FULL/DIFF execute

Jump to solution

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

0 Kudos