Suppose my system has 8GB RAM and I have installed SQL Server 2012 on it along with the DataTools. Sql server engine uses 6GB memory. Will the SSIS uses remaning memory apart from 6GB or it uses 6GB? Also is there a way to count the number of buffers used and the records accomodated in each buffer and the size of the buffer?
If am not wrong buffer refers to the RAM memory?