September 29, 2017 at 6:13 am
To save licensing costs, we're planning on migrating a SQL 2014 ENTERPRISE instance w/ 768 GB RAM ---- to a SQL 2016 STANDARD instance w/ 768 GB RAM. In reviewing the limitations for 2016 STANDARD edition I see:
( https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2016 )
Maximum memory for buffer pool per instance of SQL Server Database Engine: 128 GB
Maximum memory utilized per instance of Reporting Services: 64 GB
Does this mean the 768 GB RAM over-allocation of 640 GB (for BP) and 704 GB (for SSRS) is useless?
September 29, 2017 at 6:27 am
Express12 - Friday, September 29, 2017 6:13 AMDoes this mean the 768 GB RAM over-allocation of 640 GB (for BP) and 704 GB (for SSRS) is useless?
Yes
And if you have DBs and activity such that you need 3/4 of a terabyte of memory, it's going to die on Standard Edition. With the previous Enterprise-only features becoming available in the lower editions, the distinguishing feature of Enterprise edition is around performance, scalability and availability. Standard edition does not support the same level of performance and throughput as Enterprise.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply