• richardmgreen1 - Monday, August 7, 2017 9:29 AM

    It's my understanding that SSAS will take a proportion of the 12GB for it's own use.

    Wrong. SSAS, SSRS, SSIS and SQL Server (Data Engine) are all separate services and use their own resources. Limiting the data engine will 12GB, on a 16GB server, will leave 4GB any other processes. That will include SSAS, SSRS, and SSIS.

    As an example, on SQL Server Standard edition each service is limited to 64GB. This means that (potentially) SQL Server, SSAS, SSIS, and SSRS could each use 64GB of RAM at the same time, totalling 256GB. That's before you take into account OS resources.

    On your server1, therefore, that 4GB will need to be shared between SSAS, SSRS, SSIS (if you're using it) and the OS. Considering that, like I said, the OS is probably using about 2GB, that leaves the other services with only 2GB to play with between the 3 of them. That, more than likely, won't play well.

    Thom~

    Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
    Larnu.uk