• The applications besides the SQL Server Database Engine and SQL Server Integration Services are small & all are concerned with loading data into the server. (One example is using Robocopy to copy database backup files to this server so they can be restored, and there are a couple of other, minor, file import utilities.)

    Mainly, however, it is just the SQL engine and SSIS (oh, and the SQL Agent, but that is all).

    I found this article by Glenn Berry on Max Server Memory settings (http://sqlserverperformance.wordpress.com/2009/10/29/suggested-max-memory-settings-for-sql-server-20052008/), but I am not sure how much to leave for SSIS to run. (SSIS can be a real memory hog.)

    Any thoughts are appreciated! 🙂