Thanks to Mary Jo Foley of ZDNet’s tweet earlier (@maryjofoley) I’ve just read the SQL Server 2014 Licensing Datasheet and confirmed there’s two significant licensing changes for SQL Server 2014.
More memory in standard edition
Although we rarely see standard edition used in tier-1 deployments now, in SQL Server 2014 the database engine can support 128GB of memory. This is an increase from 64GB, that was often seen as too low a ceiling for modern deployments – although we could discuss whether that’s right or wrong for several hours.
High availability deployments now require Software Assurance
This change sneaked in but it’s there in the licensing data sheet. For now I’m just going to draw your attention to it and let the community digest.
Licensing for High Availability
SQL Server software can be configured so that if one server fails, its processing will be picked up, recovered and continued by another server. Beginning with SQL Server 2014, each active server licensed with SA coverage allows the installation of a single passive server used for fail-over support.
- The passive secondary server used for failover support does not need to be separately licensed for SQL Server as long as it is truly passive. If it is serving data, such as reports to clients running active SQL Server workloads, or performing any “work” such as additional backups from secondary servers, then it must be licensed for SQL Server.
- The active server license (s) must be covered with SA, and allow for one passive secondary SQL Server, with up to the same amount of compute as the licensed active server, only.
You can download the licensing guide (it’s only a 3 page document) from here.