SSIS Server Hardware requirements for the best perfomance??
I creating a SSIS server, this server will consume a database, execute the package one or two times per hour, on each execute will process 100 000 rows, It's better use SSIS server in the same SQL Server or use a SSIS standalone server?? How many ram can support this architecture?? I will execete 2 different packages at the same time, both with 2 or 3 loops, i trying to reduce this loops. Best regards!!
There are a lot of questions being asked here. The simple answer is: 100,000 rows is actually a small number of rows for SSIS. I have run multiple million row packages from the same server as host database server. The key is to find the balance in the defaultrowbuffer setting under the dataflow properties. This will limit the number of rows in memory, thus limiting the amount of RAM needed to run the package. As far as how much RAM can support this architecture is set by the OS and SQL Server edition. How this helps.