Highlighted
Maol1
1 Nickel

Limit parallelism on NMM SQL VDI Backup.

Hello,

I'm tryng to backup a SQL instance with more than 300 DB on one DDBOOST device.

I'm using the MSSQL: saveset but i can see that i've about one job for one DB in the running portion of the job, at the same time.

This mean about 300 parallel stream, with obviuously poor performance.

On the client the parallelism is set to 16, but networker seems to ignore this limitation.

The nw server, client, and module version is 8.2

How can I limit the parallelism of this job?

Thanks

Lorenzo

0 Kudos
8 Replies
Deb_PS
2 Iron

Re: Limit parallelism on NMM SQL VDI Backup.

What is setting for the "Stripe" for the SQL backup?

Alternatively can you run a Manual Backup from the SQL server using "NetWorker User for SQL Server" and check the performance

I believe the strive setting is not proper in your case.

0 Kudos
Maol1
1 Nickel

Re: Limit parallelism on NMM SQL VDI Backup.

Hello,

i've not set the data striping on my backup command.

only nsrsqlsv -a myclient

Lorenzo

0 Kudos
oldhercules
2 Iron

Re: Limit parallelism on NMM SQL VDI Backup.

Hello,

We are using nw8.1 + nmm3, but we were also unable to resolve such problems. I think client parallelism works only if you have many savesets in the client definition, but now you have only one (MSSQL:).

A simple workaround is to create more clients with specific (MSSQL:db1, MSSQL:db2,...) saveset definitions and run them in separate, not overlapping groups. The drawback of this solution is if something changes in the environment (add/remove db) then you should not forget to change the backup config.

Maol1
1 Nickel

Re: Limit parallelism on NMM SQL VDI Backup.

Hello oldhercules,

I know that, we've this issue since we've modified the SS from MSSQL:blabla to MSSQL:

BTW we cannot mantain the specific SS for every db because on this instance there is more than 300 DB with high chance of change.

Thanks

Lorenzo

0 Kudos
crazyrov
3 Zinc

Re: Limit parallelism on NMM SQL VDI Backup.

Maol

   on the other hand you could also limit the streams coming into the DD device by reducing the target session and max session setting on the device side.

0 Kudos
ble1
5 Iridium

Re: Limit parallelism on NMM SQL VDI Backup.

SQL VDI backups are quite touchy so if you reduce available targets, they tend to fail so limiting targets might not be welcome.  And in general it would mean to have dedicated devices for SQL backup which translates to additional pool so suddenly whole setup changes.  Real solution should be to implement change on client code side.

crazyrov
3 Zinc

Re: Limit parallelism on NMM SQL VDI Backup.

Noted, Thanks H.

0 Kudos

Re: Limit parallelism on NMM SQL VDI Backup.

Hi,

NMM doesn't care of parallelism limitation set in Networker. We have seen the same with Exchange Backup.

The only way will be to limit the number of save stream on Storage Node (even if it's not ideal) or create many different client with different Save set.

Cheers

Greg

0 Kudos