August 4, 2017 at 12:13 pm
I have a 2014 Server 4 CPU and 256 gig of memory. Used for ETL for our data warehouse. When comparing configuring the server for optimal memory usage anyone have guidelines techniques for this. In an OLTP I know what I am looking for (buffer cache ratio at 100%, good PLE), but with ETL you rung the process and move on to next load. Anything special for sp_configure options anyone has seen has helped. Use only SSIS for this ETL
August 5, 2017 at 2:20 am
tcronin 95651 - Friday, August 4, 2017 12:13 PMI have a 2014 Server 4 CPU and 256 gig of memory. Used for ETL for our data warehouse. When comparing configuring the server for optimal memory usage anyone have guidelines techniques for this. In an OLTP I know what I am looking for (buffer cache ratio at 100%, good PLE), but with ETL you rung the process and move on to next load. Anything special for sp_configure options anyone has seen has helped. Use only SSIS for this ETL
Quick question, are you running both SQL Server and SSIS on the box?
😎
The SSIS packages can be memory hungry, some tasks such as sorting can consume quite large amount of memory. I would suggest if running both on the same server, that you limit the SQL Server Max Memory to as small value as possible without causing pressure on the service, guess you'll have to test your way to the optimal value.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply