Microsoft makes SQL
Server available in multiple editions, with different feature sets and
targeting different users. These editions are Mainstream editions and
Specialized editions.
Mainstream editions:
Datacenter:
SQL Server 2008 R2
Datacenter is the full-featured edition of SQL Server and is designed for
datacenters that need the high levels of application support and scalability.
It supports 256 logical processors and virtually unlimited memory. Comes along
with Stream Insight Premium edition. The Datacenter edition has been retired in
SQL Server 2012, all its features are available in SQL Server 2012 Enterprise Edition,
Enterprise:
SQL Server Enterprise
Edition includes both the core database engine and add-on services, with a
range of tools for creating and managing a SQL Server cluster. It can manage
databases as large as 524 petabytes and address 2 terabytes of memory and
supports 8 physical processors. SQL 2012 Edition supports 160 Physical
Processors.
Standard:
SQL Server Standard
edition includes the core database engine, along with the stand-alone services.
It differs from Enterprise edition in that it supports fewer active instances
(number of nodes in a cluster) and does not include some high-availability
functions such as hot-add memory (allowing memory to be added while the server is
still running), and parallel indexes.
Web
SQL Server Web Edition
is a low-TCO option for Web hosting.
Business Intelligence:
Introduced in SQL Server
2012 and focusing on Self Service and Corporate Business Intelligence. It
includes the Standard Edition capabilities and Business Intelligence tools:
PowerPivot, Power View, the BI Semantic Model, Master Data Services, Data
Quality Services and xVelocity in-memory analytics.
Workgroup:
SQL Server Workgroup
Edition includes the core database functionality but does not include the
additional services. Note that this edition has been retired in SQL Server
2012.
Express:
SQL Server Express
Edition is a scaled down, free edition of SQL Server, which includes the core
database engine. While there are no limitations on the number of databases or
users supported, it is limited to using one processor, 1 GB memory and 4 GB
database files (10 GB database files from SQL Server Express 2008 R2. It is
intended as a replacement for MSDE. Two additional editions provide a superset
of features not in the original Express Edition. The first is SQL Server
Express with Tools, which includes SQL Server Management Studio Basic. SQL
Server Express with Advanced Services adds full-
text search capability
and reporting services.
Specialized editions:
Azure:
Microsoft SQL Azure
Database is the cloud-based version of Microsoft SQL Server, presented as
software as a service on Azure Services Platform.
Compact (SQL CE):
The compact edition is
an embedded database engine. Unlike the other editions of SQL Server, the SQL
CE engine is based on SQL Mobile (initially designed for use with hand-held
devices) and does not share the same binaries. Due to its small size (1 MB DLL
footprint), it has a markedly reduced feature set compared to the other
editions. For example, it supports a subset of the standard data types, does
not support stored procedures or Views or multiple-statement batches (among
other limitations). It is limited to 4 GB maximum database size and cannot be
run as a Windows service, Compact Edition must be hosted by the application
using it. The 3.5 version includes supports ADO.NET Synchronization Services.
SQL CE does not support ODBC connectivity, unlike SQL Server proper.
Developer:
SQL Server Developer
Edition includes the same features as SQL Server 2012 Enterprise Edition, but
is limited by the license to be only used as a development and test system, and
not as production server. This edition is available to download by students
free of charge as a part of Microsoft's DreamSpark program.
Embedded (SSEE):
SQL Server 2005 Embedded
Edition is a specially configured named instance of the SQL Server Express
database engine which can be accessed only by certain Windows Services.
Evaluation:
SQL Server Evaluation
Edition, also known as the Trial Edition, has all the features of the
Enterprise Edition, but is limited to 180 days, after which the tools will
continue to run, but the server services will stop.
Fast Track:
SQL Server Fast Track is
specifically for enterprise-scale data warehousing storage and business
intelligence processing, and runs on reference-architecture hardware that is
optimized for Fast Track.
Parallel Data Warehouse (PDW):
A massively parallel
processing (MPP) SQL Server appliance optimized for large-scale data
warehousing such as hundreds of terabytes.
Datawarehouse Appliance Edition:
Pre-installed and
configured as part of an appliance in partnership with Dell & HP base on
the Fast Track architecture. This edition does not include SQL Server Integration
Services, Analysis Services, or Reporting Services.
Feature Supported by the
Editions of SQL Server 2008:
Features Supported by
the Editions of SQL Server 2008 R2:
Features Supported by
the Editions of SQL Server 2012:
Note: This post has been prepared based on the following site.
http://en.wikipedia.org/wiki/Microsoft_SQL_Server
Thanks for
following this blog. Please comment on this post if have any questions and
suggestions.
No comments:
Post a Comment