We are in process to decide weather SSIS on separate dedicated server v/s on the same database server.
I would prefer to have on dedicated server but also curious to know that it will be a network traffic will be involved which might slows the process back n forth.
If i go with dedicated server for SSIS then what kind of server configuration you are suggesting like CPU, MEMORY, DISK SPACE.
We have few SSIS packages and our databases are not that big which also resides on various instances.
We are right now confuse with dedicated v/s on the sane database server and what will be the new recommended server specification we should order?