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 query to get only rows where a change took place? (changes can go back and forth)
  • What is the DB2 equivalent of SQL Server's SET NOCOUNT ON?
  • Need to use Update statement with dynamic sql in sqlserver 2008
  • How to convert bit column to int
  • Queries for Sql Server and Oracle
  • Error While Inserting large amount of data using Insert statement in SQL Server 2008
  • 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.

  • Unable to create an db.r3.8xlarge SQL Server EE instance in ap-southeast-2
  • How to limit the SQL Server Developer edition to the Standard edition?
  • Microsoft Small Business Licensing Kick Start
  • SQL Server licensing for test environments
  • How to change sql server license in Azure VM?
  • 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… http://www.brentozar.com/archive/2010/06/sql-server-r-standard-supports-less-memory/

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