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

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 2014 are shown here by edition.

Feature	Description	Express	Standard	Business Intelligence	Enterprise
Max Processors or Processor Cores	Maximum processing power available to an instance of SQL Server 2014 Analysis Services.	N/A	Lesser of 16 cores or four processors	Maximum supported by OS	Maximum supported by OS
Max Memory	Maximum RAM available to SQL Analysis Services.	N/A	64GB	Maximum supported by OS	Maximum supported by OS
Multidimensional BI Semantic Model	Cube-based OLAP data modeling technology included in previous versions of SQL Server.	N/A	Yes—Limited to three partitions, no proactive caching, additional limitations	Yes	Yes
Data Mining Support	Tools to analyze volumes of historical

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