Microsoft SQL Server 2012 Standard | 2 Core License | Retail
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 SLU with Software Assurance? It can be purchased here
Server + CAL Licensing (Standard Edition)
- Server License: One license per server.
- 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.
FEATURES:
SQL Server 2012 Standard - 2 core license
Feature | SQL Server 2012 Standard Edition | SQL Server 2012 Enterprise Edition |
---|---|---|
Maximum Compute Capacity (per instance) | Limited to lesser of 4 Sockets or 16 Cores | OS Maximum |
Maximum Memory Utilization (per instance) | 64 GB | OS Maximum |
High Availability | Basic Availability Groups, 2 nodes | Always On Availability Groups, multi-database failover, 4+ nodes |
Online Operations | Index rebuilds online | Index rebuilds, online page/columnstore compression, table partitioning online |
Performance | Basic performance features | Advanced performance features (In-Memory OLTP, Resource Governor, Buffer Pool Extension) |
Security | Basic security features | Advanced security features (Transparent Data Encryption, Extensible Key Management, Auditing, User-defined roles) |
Data Warehousing | Basic DW capabilities | Advanced DW capabilities (Columnstore indexes, Data Compression, Partitioning, Star Join Optimization) |
Business Intelligence | Basic BI capabilities | Advanced BI capabilities (Advanced Analytics, PowerPivot for SharePoint, Power View) |
Data Mining | Basic data mining | Advanced data mining (Data Mining Add-ins, Predictive Analytics) |
Database Snapshot | Not supported | Supported |
Enterprise Manageability | Basic management tools | Advanced manageability (Policy-Based Management, Data-tier Applications, Multi-Server Management) |
Partitioning | Not supported | Supported |
Data Compression | Not supported | Supported |
Table and Index Partitioning | Not supported | Supported |
Backup Compression | Supported | Supported |
Audit | Basic auditing | Advanced auditing (Server Audit Specification) |
Resource Governor | Not supported | Supported |
Replication | Standard Replication | Advanced Replication (Peer-to-Peer, Merge) |
SQL Server Integration Services (SSIS) | Basic SSIS features | Advanced SSIS features (SSIS Scale Out, Advanced Transformations) |
Master Data Services | Not supported | Supported |
Data Quality Services | Not supported | Supported |
PowerPivot for SharePoint | Not supported | Supported |
Power View | Not supported | Supported |
- Please note: You will need to purchase a minimum of 2x 2 Core licenses to meet Microsoft’s minimum requirement of 4 cores per SQL server installation.
- This edition of Microsoft SQL Server 2012 Standard will give you the capability to provide access to your entire office, and at the same time utilize the full 128GB capacity per server instance for your data needs.
Please note: This product is out of support from Microsoft as of July 12, 2022. You will still be able to activate the software, but not receive updates.
Delivery, Returns & Tech Support:
- All orders placed before 2PM PST M-F (excluding holidays) will be fulfilled the same day.
- 7-day return policy on most licenses if unused.
- Questions about licensing or what to purchase? Call/text/email or chat with us!
Thank you for choosing ESS - Your #1 Software Dudes!!
What do I get with my purchase?
You receive a product key, download link and install instructions.
How do I get the download?
Most products are delivered digitally via email within 30 minutes of purchase.
What if I need help?
We provide installation support free with all purchases. Just reach out if you need help, we're here!
Other questions?
Give us a call or chat instantly.
Read over 1,000+ reviews that rated ESS 4.9/5 stars
Our customer feedback reflects unparalleled customer satisfaction. With a focus on delivering tailored IT and software solutions, ESS stands as a beacon of reliability and excellence in the industry. Experience their commitment to quality and efficiency firsthand for your business needs.
Our products