Updated: July 15, 2020 (June 2, 2016)

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 can process and return results from large, complex datasets. The key related features for SQL Server 2016 are shown here by edition.

Feature	Description	Express	Standard	Enterprise
Max Processors or Processor Cores	Maximum processing power available to an instance of SQL Server Analysis Services.	N/A	Lesser of 24 cores or four processors	Maximum supported by OS
Max Memory	Maximum RAM available to SQL Analysis Services.	N/A	128GB	Maximum supported by OS
Multidimensional BI Semantic Model	Cube-based data analysis using MDX query language.	N/A	Yes—Limited to three partitions, no proactive caching, additional limitations	Yes
Data Mining Support	Tools to analyze volumes of historical data to understand trends to help predict future trends.	N/A	Yes—Limited to standard algorithms and standard data mining tools

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