Microsoft SQL Server 2014 Licensing Explanation
Overview | Licensing | Versions | Comparison | Software Assurance | Per Core Explanation | Contact | View 2016
Microsoft SQL Server licensing made simple. |
StandardThe most affordable way to get sql, this option is great for small (1 – 30) users or devices.Requirements:
Your price: $82999 |
Standard 2 CoreMicrosoft SQL 2 Core license comes with unlimited users and can be enhanced by speeding up storage and memory. Cost effective when you have more than 31 users on a system.Requirements:
Your price: $3,35299 |
Business IntelligenceBusiness Intelligence edition comes with the full suite of analytical tools to get the most out of your data. Business intelligence licenses are typically bolted on to existing database farms and licensing is by user and device not by Core.Requirements:
Your price: $7,55999 |
Enterprise 2 CoreMicrosoft SQL Enterprise 2 Core license comes with unlimited users and can be enhanced by speeding up storage and memory.Requirements:
Your price: $13,70999 |
StandardSQL Server Standard provides core data management and business intelligence capabilities for non-critical workloads with minimal IT resources. |
|
EnterpriseSQL Server Enterprise delivers comprehensive high-end datacenter capabilities for demanding database and business intelligence requirements. |
|
Business IntelligenceSQL Server Business Intelligence empowers organizations to build and deploy secure, scalable and manageable self-service corporate BI solutions. |
Features | Enterprise | Business Intelligence | Standard |
---|---|---|---|
Maximum number of cores | OS Max | 16 cores-DBOS Max-AS&RS2 | 16 cores |
Maximum memory utilized per instance | OS Max | 128 GB | 128 GB |
Maximum size | 524 PB | 524 PB | 524 PB |
Programmability (T-SQL, data types, FileTable) | |||
SQL Server Management Studio | |||
Policy-based management | |||
Basic OLTP | |||
Basic security (Separation of duties, basic auditing) | |||
Basic high availability3 | |||
Built-in data connectors | |||
Basic data integration (SSIS, designer transforms) | |||
Basic reporting4 | |||
Basic corporate BI (Analytics, multidimensional semantic model, data mining) | |||
Self-service business intelligence (Alerting, Power View, Power Pivot for SharePoint Server) | |||
Advanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analytics engine, advanced data mining) | |||
Enterprise data management (Data Quality Services, Master Data Services) | |||
Advanced data integration (Fuzzy grouping and lookup, change data capture) | |||
Advanced security (SQL Server audit, transparent data encryption) | |||
Data warehousing (In-memory columnstore, compression, partitioning) | |||
Advanced high availability (AlwaysOn, multiple, active secondaries; multi-site, geo-clustering) | |||
Advanced transaction processing (In-memory OLTP) |
1 Specifications are for SQL Server Express core.
2 Analysis Services & Reporting Services.
3 Basic includes log shipping, database mirroring, Windows Server Core support and two-node Failover Clustering.
4 Basic reporting is available in Express with Advanced Services.
2 Analysis Services & Reporting Services.
3 Basic includes log shipping, database mirroring, Windows Server Core support and two-node Failover Clustering.
4 Basic reporting is available in Express with Advanced Services.
SQL Server Core Factor Table* | |
---|---|
Processor Type | Core Factor |
All processors not mentioned below | 1 |
AMD Processors 31XX, 32XX, 33XX, 41XX, 42XX, 43XX, 61XX, 62XX, 63XX Series Processors with 6 or more cores | 0.75 |
Single-Core Processors | 4 |
Dual-Core Processors | 2 |
* This is an example of how to calculate core license requirements and the core factor table. The core factor table is subject to change.
Feeling a little lost? Have some questions? Call us at 800-318-1439 (between 6am and 5pm PT), or use the handy form below and we'll get back to you as soon as possible. |