2

I’m in the process of doing the specification for a new server that will host SQL Server 2012 including SSIS, SSRS and SSAS

I’m aware SQL Server 2012 Standard has a limit of 64GB. However from what I’ve been reading today it looks like that limit is just for the database engine and we can install SQL Standard on a machine that has more than 64GB Ram; and SSIS, SSRS have their own separate 64GB limit.

Can anyone confirm that my understanding is correct?

thanks!

migrated from stackoverflow.com Feb 3 '16 at 5:56

This question came from our site for professional and enthusiast programmers.

  • 2
    yup you're right. keep in mind that the other services (integration and reporting) use their own memory space. The memory limit you are talking about only applies to the DB engine, so make sure the server has enough to fully utilize the DB engine plus the other services running on the machine. – Jeremy Jan 19 '16 at 12:27
  • just for information purposes - ozar.me/2014/03/good-news-sql-server-standard-editions-limits – Devart Jan 19 '16 at 12:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy