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.