Deck 2

Question 1

Enterprise Edition

Answer 1

Everything is limited only by the operating system. Maximum relational db size 534 PB

Question 2

Business Intelligence

Answer 2

Maximum Compute Capacity Used by a Single Instance -
Limited to lesser of 4 Sockets or 16 cores
Maximum Memory Utilized per instance of SQL Server Database Engine - 64 GB
Maximum relational db size 534 PB
Everything else is only limited by what the operating system can handle

Question 3

Standard

Answer 3

Maximum Compute Capacity Used by a Single Instance -
Limited to lesser of 4 Sockets or 16 cores
Maximum Compute Capacity Used by a Single Instance (analysis and reporting) -
Limited to lesser of 4 Sockets or 16 cores
Maximum Memory Utilized per instance of SQL Server Database Engine - 64 GB
Maximum Memory Utilized per instance of SQL Server Reporting Engine - 64 GB
Maximum relational db size 534 PB

Question 4

Web

Answer 4

Maximum Compute Capacity Used by a Single Instance -
Limited to lesser of 4 Sockets or 16 cores
Maximum Compute Capacity Used by a Single Instance (analysis and reporting) -
Limited to lesser of 4 Sockets or 16 cores
Maximum Memory Utilized per instance of SQL Server Database Engine - 64 GB
Maximum Memory Utilized per instance of SQL Analysis services - Not available
Maximum Memory Utilized per instance of SQL Server Reporting Engine - 64 GB
Maximum relational db size 524 PB

Question 5

Express with Advanced Services

Answer 5

Maximum Compute Capacity Used by a Single Instance -
Limited to lesser of 1 Socket or 4 cores
Maximum Compute Capacity Used by a Single Instance (analysis and reporting) -
Limited to lesser of 1 Socket or 4 cores
Maximum Memory Utilized per instance of SQL Server Database Engine - 1 GB
Maximum Memory Utilized per instance of SQL Anaylsis services - Not available
Maximum Memory Utilized per instance of SQL Server Reporting Engine - 4 GB
Maximum relational db size 10 GB

Question 6

Express with Tools

Answer 6

?

Question 7

Express

Answer 7

?

Question 8

Virtualization

Answer 8

SQL Server 2012 is supported in virtual machine environments running on the Hyper-V role in:
Windows Server 2008 SP2 Standard, Enterprise and Datacenter editions
Windows Server 2008 R2 SP1 Standard, Enterprise, and Datacenter editions.
Windows Server 2012 Datacenter and Standard editions.

Microsoft recommends shutting down the SQL server, before shutting down the virtual machine.

Question 9

Instance Features

Answer 9

These can operate side by side and are seperate for each instance of SQL server.
The features:
Database Engine Services
SQL Server Replication
Full-text and semantic Extractions for search
Data Quality Services
Analysis Services
Reporting Services - native

Question 10

Shared Features

Answer 10

These only need to be installed once and all the instances on a single server can use them.
The features:
Reporting Services - Sharepoint
Reporting Services Add-in for Sharepoint products
Data Quality Clients
SQL Server Data Tools
Client Tools Connectivity
Integration Services
Client Tools Backward Compatiblity
Client Tools Software Development Kit
Documentation Components
Management Tools - Basic
Management Tools - Complete
Distributed Replay Controller
Distributed Replay Client
SQL Client Connectivity SDK
Master Data Services