July 9, 2012 at 5:39 am
Hi All,
I am sql developer and recently I got a server for administration, but that was build by another team. That server having 24 GB of RAM. Out of 24 GB, only 1966 MB is allocated to sql server engine and rest is assigned to OS and other processes. when I reached out that team and asked to increase it up to 17-19 GB. That team said that SSIS need more memory then sql engine. so we kept rest memory for SSIS processes. currently our sql queries are running very slow. Specially they are more slow when we pull data from this server to another using SSIS. please suggest how much memory we can allocate to sql engine. This is also important point here that we'll have a lot of SSIS work in this server.
Thanks
Sneh
July 9, 2012 at 5:55 am
There is no way to answer that without sitting down at your server and investigating.
With 24GB of memory, 4GB should be left for the OS, so SQL server and SSIS share that 20GB. How much SSIS needs I can't answer, you need to investigate how much it uses and set SQL to use the rest. Or set SQL to use max 20 and let the OS manage taking that away when SSIS needs. That's probably not the best though
If SSIS is causing problems with SQL, I would suggest moving SSIS off onto another server where it can't interfere.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply