Parallel Execution of SSIS (ETL) across multiple SQL databases

120

Question: Parallel Execution of SSIS (ETL) across multiple SQL databases

I have multitenancy database (one DB per customer). And at present sql error we have set the SQL memory to 60 percent of RAM and running ETL across one site at a time.

Is it possible to run ETLs across multiple sites/database at the same time?

Note - During ETL execution other operation would be slow as ETL uses maximum RAM, hence wanted to know can two sql error ETLs be run at a same across different database.

Total Answers: 1

24

Answers 1: of Parallel Execution of SSIS (ETL) across multiple SQL databases

SSIS Packages can be executed in parallel. However, as your Operational databases are on the same server, and the database that you are importing to is also on the same server, I am failing to see how that would speed up the ETL, unless the databases are on separate sql error disks which can help parallelize the reads and writes.

Also it may be more dangerous, as if you cannot afford running ETL at the point in time (like when the businesses open), you will have to stop sql error all packages, and then restart all of them

Recent Blog

Contains into JSON array PostgreSQL

May 29, 2023

Getting all th tags and testing values with playwright

May 29, 2023

Spring - Enum in RestControllers?

May 29, 2023

Higher Order Components - React.JS

May 29, 2023

Parser rule does not produce an error for invalid input

May 29, 2023

Remove "Some" keyword from string println! in rust [duplicate]

May 29, 2023

How to continue using a powershell script after it finished

May 29, 2023

Does not render NLog property value in logs when using ScopeContext.PushProperty in OnActionExecutedAsync()

May 29, 2023

What will be the formula for conditional formatting to highlight the duplicates in horizontally for multiple rows in google sheet?

May 29, 2023

NVDA calls out incomplete error message and twice

May 29, 2023