June 6, 2018 at 9:18 am
This question is in regards to setting Max Memory between the two instances and SSIS. I already know with SSIS that you can't allocate memory directly to it like and instance or SSAS. What I'm wanting
to do is change the memory between the two instances on the fly. By the way, this is a data warehouse process utilizing lots of SSIS. The Source Database to build the warehouse/cube is on the default instance.
The databases(edw and staging databases are on the named instance. SSAS is on a completely different server. What I want to do is to dynamically change the memory allocation between the two instances once
the first step of the Initial Load job is finished cause that is the source to edw step. Will not need the default instance after that step and I want to allocate more memory to the named instance at that point. My overall
question is should I utilize the command DBCC FREESYSTEMCACHE on the default instance just prior to reconfiguring the memory on the named instance because even if you change the memory allocation the default instance won't
free up the memory? Since SSIS is heavily used I realize that I need to leave enough memory unallocated so that I won't run into memory errors during the ETL Process.
We have had lots of SSIS Memory warnings and Errors while doing our steps to load the Cube. One dimension in this is that we moved SSAS off of this server entirely, so the only objects competing for memory now are the two instances,
SSIS and the OS.
Thanks in advance
June 6, 2018 at 9:23 am
ericwenger1 - Wednesday, June 6, 2018 9:18 AMbecause even if you change the memory allocation the default instance won't free up the memory
Are you sure? I used to do it quite a bit in a previous job,and it did give up the memory; it sometimes took a few seconds though.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply