
Microsoft SQL Server 2017 Standard License PN: 228-11135
Microsoft SQL Server 2017 StandardĀ License - PN: 228-11135
Ā
FEATURES:
Ā
SQL Server 2017 Edition Comparison
Feature |
SQL Server 2017 Express |
SQL Server 2017 Standard - This Edition |
SQL Server 2017 Enterprise |
|---|---|---|---|
| Maximum Compute Capacity (per instance) | Limited to lesser of 1 Socket or 4 Cores | Lesser of 4 Sockets or 24 Cores | OS Maximum |
| Maximum Memory Utilization (per instance) | 1 GB for Database Engine, 352 MB for SQL Server Express with Advanced Services | 128 GB | OS Maximum |
| High Availability | Not supported | Basic Availability Groups | AlwaysOn Availability Groups, multi-database failover, multiple synchronous replicas |
| Online Operations | Not supported | Basic online operations | Advanced online operations including online index rebuilds |
| Performance | Basic performance features | Standard performance features | Advanced performance features (In-Memory OLTP, Adaptive Query Processing, Advanced analytics) |
| Security | Basic security features | Basic security features | Advanced security features (Always Encrypted, Row-level security, Dynamic data masking) |
| Data Warehousing | Not supported | Basic DW capabilities | Advanced DW capabilities (Columnstore indexes, Data Compression, Partitioning) |
| Business Intelligence | Not supported | Basic BI capabilities | Advanced BI capabilities (Power BI Report Server, Advanced analytics) |
| Data Mining | Not supported | Basic data mining | Advanced data mining |
| Database Snapshot | Not supported | Not supported | Supported |
| Enterprise Manageability | Basic management tools | Standard management tools | Advanced manageability (Policy-Based Management, Data-tier Applications, Multi-Server Management) |
| Partitioning | Not supported | Not supported | Supported |
| Data Compression | Not supported | Not supported | Supported |
| Table and Index Partitioning | Not supported | Not supported | Supported |
| Backup Compression | Not supported | Supported | Supported |
| Audit | Not supported | Basic auditing | Advanced auditing (Server Audit Specification) |
| Resource Governor | Not supported | Not supported | Supported |
| Replication | Not supported | Standard Replication | Advanced Replication (Peer-to-Peer, Merge) |
| SQL Server Integration Services (SSIS) | Basic SSIS features | Standard SSIS features | Advanced SSIS features (SSIS Scale Out, Advanced Transformations) |
| Master Data Services | Not supported | Not supported | Supported |
| Data Quality Services | Not supported | Not supported | Supported |
| Power BI Report Server | Not supported | Not supported | Supported |
| PowerPivot for SharePoint | Not supported | Not supported | Supported |
| Power View | Not supported | Not supported | Supported |
| Ā |
Ā
How to license SQL Server?
Ā
Licensing Models
- Core-based Licensing: Applies to the Enterprise Edition and offers unlimited Virtualization Rights when all physical cores are licensed.
- Server + CAL (Client Access License): Applies to the Standard Edition and requires a license for each server and a CAL for each user or device accessing the server.
Ā
Core-Based Licensing (Standard and Enterprise Editions)
+--------------------+
| SERVER |
|--------------------|
| Core 1 | Core 2 |
| Core 3 | Core 4 |
+--------------------+
| Minimum 4 Core Licenses per Processor |
- Core Licenses: Sold in packs of two. Each physical core must have a license.
- Minimum Requirement: A minimum of four core licenses per physical processor.
- Virtualization: With Software Assurance, allows for unlimited virtualization. This license is a retail pack with 2 cores without SA, so the virtualization will depend upon the number of vCPU's licensed.
- Looking for the SKU with Software Assurance? It can be purchased here
Ā
Server + CAL Licensing (Standard Edition)
- Server License: One license per server. - This edition
- CALs: One CAL per user or device accessing the server.
Virtualization and Containers
+----------------------------+
| HOST |
+----------------------------+
| VM 1 | VM 2 | VM 3 | VM 4 |
+----------------------------+
| Each VM must be licensed |
+----------------------------+
- Enterprise Edition: Offers flexibility with virtualization, allowing for multiple VMs and containers.
- Standard Edition: Limited to a lower number of VMs and containers unless each VM is licensed individually.
Licensing for Specific Environments
- Non-production (Dev/Test): Developer Edition is free and provides the full feature set for development and testing purposes.
- High Availability: Passive secondary servers for failover are included in the licensing of the primary server.
Delivery, Returns & Tech Support:Ā
Ā
- All orders placed before 2PM PST M-F (excluding holidays) will be fulfilled the same day.
- 30-day return policy on most licenses if unused/non-activated.
- Questions about licensing or what to purchase? Call/text/email or chat with us!
Ā
Thank you for choosing ESS - Your #1 Software Dudes!!
Ā
Microsoft SQL Server 2017 Standard License PN: 228-11135
Microsoft SQL Server 2017 StandardĀ License - PN: 228-11135
Ā
FEATURES:
Ā
SQL Server 2017 Edition Comparison
Feature |
SQL Server 2017 Express |
SQL Server 2017 Standard - This Edition |
SQL Server 2017 Enterprise |
|---|---|---|---|
| Maximum Compute Capacity (per instance) | Limited to lesser of 1 Socket or 4 Cores | Lesser of 4 Sockets or 24 Cores | OS Maximum |
| Maximum Memory Utilization (per instance) | 1 GB for Database Engine, 352 MB for SQL Server Express with Advanced Services | 128 GB | OS Maximum |
| High Availability | Not supported | Basic Availability Groups | AlwaysOn Availability Groups, multi-database failover, multiple synchronous replicas |
| Online Operations | Not supported | Basic online operations | Advanced online operations including online index rebuilds |
| Performance | Basic performance features | Standard performance features | Advanced performance features (In-Memory OLTP, Adaptive Query Processing, Advanced analytics) |
| Security | Basic security features | Basic security features | Advanced security features (Always Encrypted, Row-level security, Dynamic data masking) |
| Data Warehousing | Not supported | Basic DW capabilities | Advanced DW capabilities (Columnstore indexes, Data Compression, Partitioning) |
| Business Intelligence | Not supported | Basic BI capabilities | Advanced BI capabilities (Power BI Report Server, Advanced analytics) |
| Data Mining | Not supported | Basic data mining | Advanced data mining |
| Database Snapshot | Not supported | Not supported | Supported |
| Enterprise Manageability | Basic management tools | Standard management tools | Advanced manageability (Policy-Based Management, Data-tier Applications, Multi-Server Management) |
| Partitioning | Not supported | Not supported | Supported |
| Data Compression | Not supported | Not supported | Supported |
| Table and Index Partitioning | Not supported | Not supported | Supported |
| Backup Compression | Not supported | Supported | Supported |
| Audit | Not supported | Basic auditing | Advanced auditing (Server Audit Specification) |
| Resource Governor | Not supported | Not supported | Supported |
| Replication | Not supported | Standard Replication | Advanced Replication (Peer-to-Peer, Merge) |
| SQL Server Integration Services (SSIS) | Basic SSIS features | Standard SSIS features | Advanced SSIS features (SSIS Scale Out, Advanced Transformations) |
| Master Data Services | Not supported | Not supported | Supported |
| Data Quality Services | Not supported | Not supported | Supported |
| Power BI Report Server | Not supported | Not supported | Supported |
| PowerPivot for SharePoint | Not supported | Not supported | Supported |
| Power View | Not supported | Not supported | Supported |
| Ā |
Ā
How to license SQL Server?
Ā
Licensing Models
- Core-based Licensing: Applies to the Enterprise Edition and offers unlimited Virtualization Rights when all physical cores are licensed.
- Server + CAL (Client Access License): Applies to the Standard Edition and requires a license for each server and a CAL for each user or device accessing the server.
Ā
Core-Based Licensing (Standard and Enterprise Editions)
+--------------------+
| SERVER |
|--------------------|
| Core 1 | Core 2 |
| Core 3 | Core 4 |
+--------------------+
| Minimum 4 Core Licenses per Processor |
- Core Licenses: Sold in packs of two. Each physical core must have a license.
- Minimum Requirement: A minimum of four core licenses per physical processor.
- Virtualization: With Software Assurance, allows for unlimited virtualization. This license is a retail pack with 2 cores without SA, so the virtualization will depend upon the number of vCPU's licensed.
- Looking for the SKU with Software Assurance? It can be purchased here
Ā
Server + CAL Licensing (Standard Edition)
- Server License: One license per server. - This edition
- CALs: One CAL per user or device accessing the server.
Virtualization and Containers
+----------------------------+
| HOST |
+----------------------------+
| VM 1 | VM 2 | VM 3 | VM 4 |
+----------------------------+
| Each VM must be licensed |
+----------------------------+
- Enterprise Edition: Offers flexibility with virtualization, allowing for multiple VMs and containers.
- Standard Edition: Limited to a lower number of VMs and containers unless each VM is licensed individually.
Licensing for Specific Environments
- Non-production (Dev/Test): Developer Edition is free and provides the full feature set for development and testing purposes.
- High Availability: Passive secondary servers for failover are included in the licensing of the primary server.
Delivery, Returns & Tech Support:Ā
Ā
- All orders placed before 2PM PST M-F (excluding holidays) will be fulfilled the same day.
- 30-day return policy on most licenses if unused/non-activated.
- Questions about licensing or what to purchase? Call/text/email or chat with us!
Ā
Thank you for choosing ESS - Your #1 Software Dudes!!
Ā
Product Information
Product Information
Shipping & Returns
Shipping & Returns
Description
Microsoft SQL Server 2017 StandardĀ License - PN: 228-11135
Ā
FEATURES:
Ā
SQL Server 2017 Edition Comparison
Feature |
SQL Server 2017 Express |
SQL Server 2017 Standard - This Edition |
SQL Server 2017 Enterprise |
|---|---|---|---|
| Maximum Compute Capacity (per instance) | Limited to lesser of 1 Socket or 4 Cores | Lesser of 4 Sockets or 24 Cores | OS Maximum |
| Maximum Memory Utilization (per instance) | 1 GB for Database Engine, 352 MB for SQL Server Express with Advanced Services | 128 GB | OS Maximum |
| High Availability | Not supported | Basic Availability Groups | AlwaysOn Availability Groups, multi-database failover, multiple synchronous replicas |
| Online Operations | Not supported | Basic online operations | Advanced online operations including online index rebuilds |
| Performance | Basic performance features | Standard performance features | Advanced performance features (In-Memory OLTP, Adaptive Query Processing, Advanced analytics) |
| Security | Basic security features | Basic security features | Advanced security features (Always Encrypted, Row-level security, Dynamic data masking) |
| Data Warehousing | Not supported | Basic DW capabilities | Advanced DW capabilities (Columnstore indexes, Data Compression, Partitioning) |
| Business Intelligence | Not supported | Basic BI capabilities | Advanced BI capabilities (Power BI Report Server, Advanced analytics) |
| Data Mining | Not supported | Basic data mining | Advanced data mining |
| Database Snapshot | Not supported | Not supported | Supported |
| Enterprise Manageability | Basic management tools | Standard management tools | Advanced manageability (Policy-Based Management, Data-tier Applications, Multi-Server Management) |
| Partitioning | Not supported | Not supported | Supported |
| Data Compression | Not supported | Not supported | Supported |
| Table and Index Partitioning | Not supported | Not supported | Supported |
| Backup Compression | Not supported | Supported | Supported |
| Audit | Not supported | Basic auditing | Advanced auditing (Server Audit Specification) |
| Resource Governor | Not supported | Not supported | Supported |
| Replication | Not supported | Standard Replication | Advanced Replication (Peer-to-Peer, Merge) |
| SQL Server Integration Services (SSIS) | Basic SSIS features | Standard SSIS features | Advanced SSIS features (SSIS Scale Out, Advanced Transformations) |
| Master Data Services | Not supported | Not supported | Supported |
| Data Quality Services | Not supported | Not supported | Supported |
| Power BI Report Server | Not supported | Not supported | Supported |
| PowerPivot for SharePoint | Not supported | Not supported | Supported |
| Power View | Not supported | Not supported | Supported |
| Ā |
Ā
How to license SQL Server?
Ā
Licensing Models
- Core-based Licensing: Applies to the Enterprise Edition and offers unlimited Virtualization Rights when all physical cores are licensed.
- Server + CAL (Client Access License): Applies to the Standard Edition and requires a license for each server and a CAL for each user or device accessing the server.
Ā
Core-Based Licensing (Standard and Enterprise Editions)
+--------------------+
| SERVER |
|--------------------|
| Core 1 | Core 2 |
| Core 3 | Core 4 |
+--------------------+
| Minimum 4 Core Licenses per Processor |
- Core Licenses: Sold in packs of two. Each physical core must have a license.
- Minimum Requirement: A minimum of four core licenses per physical processor.
- Virtualization: With Software Assurance, allows for unlimited virtualization. This license is a retail pack with 2 cores without SA, so the virtualization will depend upon the number of vCPU's licensed.
- Looking for the SKU with Software Assurance? It can be purchased here
Ā
Server + CAL Licensing (Standard Edition)
- Server License: One license per server. - This edition
- CALs: One CAL per user or device accessing the server.
Virtualization and Containers
+----------------------------+
| HOST |
+----------------------------+
| VM 1 | VM 2 | VM 3 | VM 4 |
+----------------------------+
| Each VM must be licensed |
+----------------------------+
- Enterprise Edition: Offers flexibility with virtualization, allowing for multiple VMs and containers.
- Standard Edition: Limited to a lower number of VMs and containers unless each VM is licensed individually.
Licensing for Specific Environments
- Non-production (Dev/Test): Developer Edition is free and provides the full feature set for development and testing purposes.
- High Availability: Passive secondary servers for failover are included in the licensing of the primary server.
Delivery, Returns & Tech Support:Ā
Ā
- All orders placed before 2PM PST M-F (excluding holidays) will be fulfilled the same day.
- 30-day return policy on most licenses if unused/non-activated.
- Questions about licensing or what to purchase? Call/text/email or chat with us!
Ā
Thank you for choosing ESS - Your #1 Software Dudes!!
Ā














