Memory Limits for SQL Server 2008 R2 Standard and Analysis Services

According to MSDN, the memory limit for SQL Server 2008 Standard edition is 64 GB. Does anyone know if this total is for SQL Server only, for each service you run on that instance (SQL, SSAS, SSIS), or a single total that is shared among all services you run within that instance.

For example, if I want to allocate 64 GB of memory to SQL, will there be any memory available under my license for me to run any other services on that instance?

  • How to get the stored procedure result using perl?
  • How to calculate age (in years) based on Date of Birth and getDate()
  • Getting related tags from SQL Server when you have filtered down
  • Authentication in SSIS SMTP Connection Manager?
  • how to parse on column and add more records to a table?
  • How may I change the default TRANSACTION ISOLATION LEVEL in SQL Server 2005?
  • Note: This is not a question about physical memory limitations, as my server has more than enough physical memory to meet my allocation requirements. I am only curious to know if I will be limited by the license itself.

  • How to limit the SQL Server Developer edition to the Standard edition?
  • Microsoft Small Business Licensing Kick Start
  • SQL Server 2008 Licensing when splitting Report Manager and Report Service on different machines
  • One Solution collect form web for “Memory Limits for SQL Server 2008 R2 Standard and Analysis Services”

    It looks like it’s 64GB limit is per instance, not server. Other people were asking the same question in this article…

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.