Page 10 - DCAP508_DATABASE_ADMINISTRATION

Database Administration

Notes Enterprise

Enterprise is the high-end edition with the full attribute set. SQL Server 2008 R2 Enterprise
provides a complete, trusted data platform for challenging, mission-critical applications, BI
solutions, and reporting. Some of the new traits incorporated in this edition comprise assistance
for up to eight processors, conscription of up to 25 managed instances of SQL Server into a single
Utility Control Point, Power Pivot for SharePoint, data density support for UCS-2 Uni-code,
Master Data Services, assistance for up to four virtual machines, and the potential to maintain up
to 2 terabytes of RAM. It still offers high levels of accessibility, scalability, and safety, and
provides classic SQL Server 2008 traits like data and backup compression, Resource Governor,
Transparent Data Encryption (TDE), advanced data mining algorithms, mirrored backups, and
Oracle publishing.
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.

Standard

SQL Server 2008 R2 Standard is an inclusive data management and BI platform that offers
medium-class solutions for minor organizations. It does not comprise all the bells and whistles
incorporated in Datacenter and Enterprise; though, it continues to provide best-in-class ease of
use and manageability. Backup compression, which was an enterprise trait with SQL Server
2008, is now a trait included with the SQL Server 2008 R2 Standard. Compared to Datacenter and
Enterprise, Standard assists only up to four processors, up to 64 GB of RAM, one virtual machine,
and two failover clustering nodes

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

At a much more reasonable price compared to Datacenter, Enterprise, and Standard, SQL Server
2008 R2 Web is concentrated on service suppliers hosting Internet-facing Web serving
surroundings. Dissimilar to Workgroup and Express, this edition doesn't have a tiny database
size restriction, and it assists four processors and up to 64 GB of memory. SQL Server 2008 R2
Web does not provide the similar premium traits located in Datacenter, Enterprise, and Standard;
though, it is still the ideal platform for hosting Websites and Web applications.
SQL Server Web Edition is a low-TCO option for Web hosting.

Workgroup

Workgroup is a cost-effective, protected, and dependable database and reporting platform meant
for implementing smaller workloads than Standard. For instance, this edition is perfect for
branch office solutions like branch data storage, branch reporting, and remote synchronization.
Comparable to Web, it assists a maximum database size of 524 terabytes; though, it assists only
two processors and up to 4 GB of RAM. It is possible to improve Workgroup to Standard or
Enterprise.

SQL Server Workgroup Edition includes the core database functionality but does not include the
additional services.

4 LOVELY PROFESSIONAL UNIVERSITY