Increase Tabular Maximum Memory to 64GB in Standard Edition - by Teo Lachev

Status : 


Sign in
to vote
ID 3124867 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 2/25/2017 2:16:44 PM
Access Restriction Public


Tabular is supported in SQL Server 2016 Standard Edition but it's limited to 16 GB while Multidimensional enjoys the whopping 64 GB (although is disk-based). As a memory-resident technology, the current limitation of 16 GB is impractical for Tabular. Twice the memory is required to process the database, leaving us with a database size of no more than 5 GB to be on the safe side. 
Sign in to post a comment.