We have been working with a Data Warehouse consultant company for a year or so now. They recommended installing Talend (our ETL package) on the same VM as the MSSQL Server. I didn't push back on this initially because I didn't expect the Talend Services to be so CPU-abusive. I didn't think that we'd be seeing high CPU all the time for our small dataset that it was working with.
I'd like to have a new VM (possibly on a different VMware host than the MSSQL Server) setup and Talend installed to it. The Consultant says this will reduce performance. My theory is that if all it's doing is SQL Queries to the MSSQL DB Server it would be better to do those from a different Host/VM. If it's a network bottleneck, then I can put the 2 VMs on the same VMware host to speed up that communication. Then the VM wont' have to fight with itself for resources between Talend and MSSQL. I can tune the VMs individually if they are separated as well.
I did some searching in the Talend Documentation website and the Install Guide doesn't mention installing on the same VM as the DB or separating it.
Any advise from other Sysadmins on the Best Practice for a Talend installation architecture?
