Updated: July 15, 2020 (December 19, 2016)
Charts & IllustrationsSQL Server Analysis Services Feature Comparison
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 2016 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 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. ColumnStore features are constrained and may not provide significant benefit in a production environment. However, its availability could help developers create applications using those features that work more consistently across editions without modification.
| Feature | Description | Standard | Enterprise |
| Max processors or processor cores | Maximum processing power available to an instance of SQL Server Analysis |
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 OptionsAlready have an account? Login Now