Friday, November 16, 2018

EDITIONS OF SQL SERVER


EDITIONS OF SQL SERVER:-
======================
SQL Server 2012 Standard Edition

·         Limited to 16 Cores & 64GB of RAM
·         It includes support for two-node Always On Failover Clusters, and it’s licensed either per core or per server.

SQL Server 2012 Business Edition

·         SQL Server 2012 Business Intelligence Edition is a new member of the SQL Server family.
·         Limited to 16 cores &  64GB of RAM for db engine. However, it can use the maximum number of cores supported by the OS for Analysis Services and Reporting Services because this is BI Edition.
·         This Edition includes all of the features in the Standard edition and support for advanced BI features, but it lacks support for the advanced availability features like AlwaysOn Availability Groups and other online operations. The BI Edition supports two-node AlwaysOn Failover Clusters, and it’s licensed per server.
SQL Server 2012 Enterprise Edition
·         SQL Server 2012 Enterprise Edition has everything that SQL Server offers.
·         It supports the maximum number of cores and RAM in the host OS and provides the complete SQL Server feature set, including support for all of the advanced availability and BI features.
·         The Enterprise edition supports up to 16-node AlwaysOn Failover Clusters & AlwaysOn AG.
·         The Enterprise edition is licensed per core.
SQL Server 2012 Express Editions
SQL Server 2012 offers free edition as SQL Server Express Edition and The Express editions are limited to support for one CPU and 1GB of RAM. Databases are limited to 10GB per database.
SQL Server 2012 Web and Developer Editions.SQL Server 2012 Web Edition and SQL Server 2012 Developer Edition are same as previous versions. The Developer edition provides the same feature set as the Enterprise edition. However, it’s licensed per developer and can’t be used for production work. The Web edition is licensed only to hosting companies with a Services Provider License Agreement (SLPA).

No comments:

Post a Comment

COMMON SQL SERVER BACKUP FAILURE ERRORS AND ISSUES

  One of the most common task for a DBA’s are to perform installation of new SQL Server versions and installing patches. Most often or not e...