Updated: July 16, 2020 (December 8, 2017)

SQL Server Analysis Services Feature Comparison

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

SQL Server’s business intelligence and data-mining components (primarily Analysis Services) can process and return results from large, complex data sets. The key related features for SQL Server 2017 are shown here by edition. Express edition does not include any of the Analysis Services features and is not shown in this chart.

The feature mix changed with SQL Server 2016 SP1, released in Nov. 2016, improving the performance of Analysis Services in Standard edition. Notably, it gained limited-version ColumnStore and database compression features that formerly required Enterprise.

Feature	Description	Standard	Enterprise
Max processors or processor cores	Maximum processing power available to an instance of SQL Server Analysis Services.	Lesser of 24 cores or four processors	Maximum supported by OS
Max memory	Maximum RAM available to SQL Analysis Services.	128GB	Maximum supported by OS
Multidimensional BI semantic model

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now