Is SSIS subject to the maximum memory limitations for SQL Server 2012 Standard edition?
If I have a server with 128GB RAM and I allocate 64GB of RAM to SQL Server does SSIS utilise this memory or does it utilise the memory that is available to the OS?
I am assuming it utilises the remaining memory left to the OS since there is no settings for memory consumption and it runs as a separate service.
If anyone has any information on the available memory that should be left for SSIS to consume I would appreciate the help.