CozyRoc (12/19/2008)
This is unusual question, Marios. Why would you want to know how much memory is consumed by the SSIS service? Do you have an issue in particular?I don't think you can control SSIS service maximum memory.
The reason is that I have a server (32-bit OS) with 8 GB of RAM, hosting 2 db-engine instances and the SSIS service.
I have enabled AWE for one of the instances, setting max memory to 4 GB.
The other db-engine instance can access the default maxmemory of 3 GB (3-gb switch is enabled).
The SSIS service process can access up to the default of 2 GB (not sure if the 3-gb switch affects it as well).
I would like to limit the SSIS service to a max memory of 1 GB, if possible, to avoid memory contention among the 3 processes. But, first I want to monitor memory usage by the SSIS service, to ensure I don't starve it of needed resources.
SSAS gives one the ability to configure min/max memory, why isn't SSIS?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]