For SQL Data Collector:
Do you need SSIS (SQL Server Integration Services) installed on the server that you are collecting data from. Or can the packages be run from another server -- like the one that the MDW database is on.
This question came from our site for professional and enthusiast programmers.
Nope, you don't need SSIS on the server you are collecting data from, bits of SSIS are installed anyway when you install SQL server and this is enough for the data collector to work. All the system data collector sets work out of the box once you have set up the management data warehouse and enabled them.
The actual SSIS packages for data collector are stored within MSDB, rather than SSISDB as with a full SSIS server and they are executed by a process called Dcexec.exe.
The full architecture for how data collector works is detailed here: