June 5, 2009 at 9:11 am
We used to have 8GB RAM on sql server box using 80% by sql server where in when we started running SSIS on the same box we had perofrmance issues and buffer errors. Later we doubled the memory and the setting is not changed and now sql server is using 60% and the rest(40%) is left for SSIS.
Based on this setting do you guys recommend any change on this setting , do i need allocate 50 -50 for sql server and SSIS?
June 5, 2009 at 11:10 am
If this is production, I'd always recommend running SSIS from another utility/app server, but regardless, you should set your max server memory settings appropriately to allow memory for the O/S and any other apps (hopefully only SSIS?).
Being that you have 8GB, without knowing anything about the machine, I'd say give SQL 5gb and leave 3GB for the O/S and SSIS.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply