«

»

ago 26

SQL Server Editions

São tantos recursos que muitas vezes precisamos pesquisar para saber a diferença entre as edições do SQL como Datacenter, Enterprise, Standard, Web, Workgroup e Express.

Para facilitar a leitura estamos listando as principais diferenças mas se você quiser uma lista completa, neste artigo do Technet Library você encontra todas as diferenças, podendo selecionar a versão entre 2008, 2008 R2 e 2012.

Abaixo temos as diferenças entre as edições do 2008 R2, que ainda possui as edições Datacenter (DC) e Workgroup, retiradas da versão 2012 simplificando bastante a maneira de licenciar o produto.

Esta é uma leitura obrigatória, tanto para evitar equívocos na hora de projetar a arquitetura do ambiente quanto para obter certificações Microsoft, já que os exames 70-450 e 70-451 ainda estão disponíveis (leia aqui).

Observe que sempre digo diferença entre edições, se quiser saber a diferença entre versõeseste blog está sempre atualizado.

 

Escalabilidade e Performance

Feature Name DC Enterprise Standard Web Workgroup Express
Number of CPUs OS maximum 8 4 4 2 1
Maximum memory utilized OS maximum 2 TB 64 GB 64 GB 4 GB 1 GB
Maximum database size 524 PB 524 PB 524 PB 524 PB 524 PB 10 GB
IA64 hardware support Yes Yes
Resource governor Yes Yes
Table and index partitioning Yes Yes
Parallel index operations Yes Yes
Parallel consistency checks (DBCC) Yes Yes
Enhanced read-ahead scan Yes Yes
Scalable shared databases Yes Yes
Direct query of index views using NOEXPAND hint Yes Yes Yes
Automatic indexed view maintenance Yes Yes Yes
Automatic use of indexed views by query optimizer Yes Yes
Distributed Partitioned Views Yes Yes Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable Partial. Distributed Partitioned Views are not updatable

 

 

 

 

Alta Disponibilidade (AlwaysOn)

Feature Name DC Enterprise Standard Web Workgroup Express
Log shipping Yes Yes Yes Yes Yes
Database mirroring2 Yes Yes Yes (single thread, synchronous only) Witness only Witness only Witness only
Automatic corruption recovery from mirror Yes Yes Yes
Log stream compression Yes Yes Yes
Number of Failover clustering nodes Operating system maximum1 Operating system maximum1 2 nodes
Backup compression Yes Yes Yes3
Mirrored backups Yes Yes
Database snapshots Yes Yes
Fast recovery Yes Yes
Online indexing Yes Yes
Online page and file restore Yes Yes
Online configuration of Peer to Peer nodes Yes Yes
Hot add memory and CPU support Yes Yes

1-Windows Server 2003 supports a maximum of 8 failover cluster nodes. Windows Server 2008 supports a maximum of 16 failover cluster nodes.

2-Asynchronous database mirroring is supported only by SQL Server 2005 Enterprise Edition SP1 and later versions.

3-Backup compression for Standard edition of SQL Server is supported only in SQL Server 2008 R2 or higher versions

 

 

 

 

 

Suporte a Virtualização

Feature Name DC Enterprise Standard Web Workgroup Express
Hypervisor support Yes Yes Yes Yes Yes Yes
Guest failover clustering support for virtualization Yes Yes Yes
Hyper-V live migration Yes Yes Yes
Application mobility Yes Yes

 

 

 

 

 

Replicação

Feature Name DC Enterprise Standard Web Workgroup Express
Snapshot replication Yes Yes Yes Subscriber only Yes Subscriber only
Merge replication Yes Yes Yes Subscriber only Restricted¹ Subscriber only
Transactional replication Yes Yes Yes Subscriber only Restricted¹ Subscriber only
SQL Server change tracking Yes Yes Yes Yes Yes Yes
Publishing data from SQL Server to non SQL Server subscribers Yes Yes Yes
Publishing data from Oracle to SQL Server Yes Yes
Peer to Peer replication Yes Yes

 

 

 

 

Segurança

Feature Name DC Enterprise Standard Web Workgroup Express
Windows Integrated Authentication (including Kerberos) Yes Yes Yes Yes Yes Yes
Integration with Microsoft baseline security analyzer Yes Yes Yes Yes Yes Yes
C2 compliant audit mode1 Yes Yes Yes Yes Yes Yes
Common criteria compliance Yes Yes Yes Yes Yes Yes
Data encryption and key management Yes Yes Yes Yes Yes Yes
Module signing Yes Yes Yes Yes Yes Yes
Transport Layer Security channel encryption Yes Yes Yes Yes Yes Yes
Windows password policy support Yes Yes Yes Yes Yes Yes
User-schema separation Yes Yes Yes Yes Yes Yes
Login triggers and connection endpoints Yes Yes Yes Yes Yes Yes
Secure configuration through policy-based management Yes Yes Yes Yes Yes Yes
SQL Server audit (fine-grained auditing) Yes Yes
Transparent database encryption Yes Yes
Extensible key management Yes Yes

1-For a description of this feature see, c2 audit mode Option.

 

 

 

 

Gerenciamento para uma Instância

Feature Name DC Enterprise Standard Web Workgroup Express
Policy-Based Management Yes Yes Yes Yes Yes Yes
PowerShell support Yes Yes Yes Yes Yes Yes
SQL Server Management Object (SMO) Yes Yes Yes Yes Yes Yes
SysPrep support1 Yes Yes Yes Yes Yes Yes
SQL Server connection director Yes Yes Yes Yes Yes Yes
Dedicated admin connection Yes Yes Yes Yes Yes Yes (Under trace flag)
Policy automation (check on schedule and change) Yes Yes Yes Yes Yes
Maintenance plans Yes Yes Yes Yes Yes
Database mail Yes Yes Yes Yes Yes
Performance data collector Yes Yes Yes Yes Yes
System Center Operations Manager Management Pack Yes Yes Yes Yes Yes
Plan guides Yes Yes Yes Yes .
User instances Yes

 

 

 

 

 

Gerenciamento para múltiplas instâncias

Feature Name DC Enterprise Standard Web Workgroup Express
Support for data-tier application (DAC) operations – extract, deploy, upgrade Yes Yes Yes Yes Yes Yes
Able to enroll for multi-instance management. Yes1 Yes2 Yes Yes Yes
Multi-instance dashboard views and drilldowns Yes Yes2
Policy-based resource utilization evaluation Yes Yes2

 

 

 

 

Ferramentas de Gerenciamento

Feature Name DC Enterprise Standard Web Workgroup Express
SQL Server Configuration Manager Yes Yes Yes Yes Yes Yes
SQL CMD (command prompt tool) Yes Yes Yes Yes Yes Yes
SQL Server Migration Assistant1 Yes Yes Yes Yes Yes Yes
SQL Server Management Studio2 Yes Yes Yes Yes Yes
SQL Server Agent Yes Yes Yes Yes Yes
Database Engine Tuning Advisor Yes Yes Yes Yes Yes
SQL Server Profiler Yes Yes Yes Yes Yes No3
Analysis Services, PowerPivot IT operation dashboard Yes Yes

 

 

 

 

 

Ferramentas de Desenvolvimento

Feature Name DC Enterprise Standard Web Workgroup Express
Microsoft Visual Studio Integration Yes Yes Yes Yes Yes Yes
IntelliSense (Transact-SQL and MDX) Yes Yes Yes Yes No
(SSMS is not installed with this edition)
Business Intelligence Development Studio Yes Yes Yes Yes Yes
SQL query, edit and design tools Yes Yes Yes Yes
Version control support Yes Yes Yes Yes
MDX edit, debug, and design tools Yes Yes Yes

 

 

1 comentário

  1. Angelo Máximo Moreira Silva

    Muito bom Mercante. A lista com as features disponíveis em cada edição é um assunto importante.

Deixe uma resposta