SQL Server 2012: Übersicht und Vergleich der Editionen

Der Vollständigkeit halber ein Vergleich der verschiedenen Versionen des SQL Server 2012.

Feature Name Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Max Cap. Single Instance (SQL Server Database Engine) OS maximum Max of 4 Sockets or 16 cores Max of 4 Sockets or 16 cores Max of 4 Sockets or 16 cores Max of 1 Socket or 4 cores Max of 1 Socket or 4 cores Max of 1 Socket or 4 cores
Max Cap. Single Instance (Analysis Services, Reporting Services)  OS maximum OS maximum Max of 4 Sockets or 16 cores Max of 4 Sockets or 16 cores Max of 1 Socket or 4 cores Max of 1 Socket or 4 cores Max of 1 Socket or 4 cores
Max Mem (SQL Server Database Engine) OS maximum 64 GB 64 GB 64 GB 1 GB 1 GB 1 GB
Max Mem (Analysis Services) OS maximum OS maximum 64 GB N/A N/A N/A N/A
Max Mem (Reporting Services) OS maximum OS maximum 64 GB 64 GB 4 GB N/A N/A
Maximum relational Database size 524 PB 524 PB 524 PB 524 PB 10 GB 10 GB 10 GB
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Server Core support1 Yes Yes Yes Yes Yes Yes Yes
Log Shipping Yes Yes Yes Yes
Database mirroring Yes Yes (Safety Full Only) Yes (Safety Full Only) Witness only Witness only Witness only Witness only
Failover Clustering Yes Nodes OS maximum Yes (Node support: 2) Yes (Node support: 2)
Backup compression Yes Yes Yes
Database snapshot Yes
AlwaysOn Availability Groups Yes
SQL Server Multi-Subnet Clustering Yes
Connection Director Yes
Online page and file restore Yes
Online indexing Yes
Online schema change Yes
Fast recovery Yes
Mirrored backups Yes
Hot Add Memory and CPU2 Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Multi-instance support 50 50 50 50 50 50 50
Table and index partitioning Yes
Data compression Yes
Resource Governor Yes
Partition Table Parallelism Yes
Multiple Filestream containers Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Basic Auditing Yes Yes Yes Yes Yes Yes Yes
Fine Grained Auditing Yes
Transparent database encryption Yes
Extensible Key Management Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Server change tracking Yes Yes Yes Yes Yes Yes Yes
Merge replication Yes Yes Yes Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
Transactional replication Yes Yes Yes Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
Snapshot replication Yes Yes Yes Yes (Subscriber only Yes (Subscriber only) Yes (Subscriber only) Yes (Subscriber only)
Heterogeneous subscribers Yes Yes Yes
Oracle publishing Yes
Peer to Peer transactional replication Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Management Objects (SMO) Yes Yes Yes1 Yes Yes Yes Yes
SQL Configuration Manager Yes Yes Yes Yes Yes Yes Yes
SQL CMD (Command Prompt tool) Yes Yes Yes Yes Yes Yes Yes
SQL Server Management Studio Yes Yes Yes Yes Yes Yes
Distributed Replay – Admin Tool Yes Yes Yes Yes Yes Yes
Distributed Replay – Client Yes Yes Yes Yes
Distributed Replay – Controller Yes (Ent up to 16 clients, Dev only 1 client) Yes (1 client support only) Yes (1 client support only) Yes (1 client support only)
SQL Profiler Yes Yes Yes No2 No2 No2 No2
SQL Server Agent Yes Yes Yes Yes
MSCOM Management Pack Yes Yes Yes Yes
Database Tuning Advisor (DTA) Yes Yes Yes3 Yes3
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
User Instances Yes Yes Yes
Dedicated admin connection Yes Yes Yes Yes Yes (under trace flag) Yes (under trace flag) Yes (under trace flag)
PowerShell scripting support Yes Yes Yes Yes Yes Yes Yes
SysPrep support1 Yes Yes Yes Yes Yes Yes Yes
Support for Data-tier application component operations – extract, deploy, upgrade, delete Yes Yes Yes Yes Yes Yes Yes
Policy automation (check on schedule and change) Yes Yes Yes Yes
Performance data collector Yes Yes Yes Yes
Able to enroll as a managed instance in a multi-instance management Yes Yes Yes Yes
Standard performance reports Yes Yes Yes Yes
Plan guides and plan freezing for plan guides Yes Yes Yes Yes
Direct query of indexed views (using NOEXPAND hint) Yes Yes Yes Yes
Automatic indexed view maintenance Yes Yes Yes Yes
Distributed partitioned views Yes Dist. part. View No UP Dist. part. View No UP Dist. part. View No UP Dist. part. View No UP Dist. part. View No UP Dist. part. View No UP
Parallel indexed operations Yes
Automatic use of indexed view by query optimizer Yes
Parallel consistency check Yes
SQL Server utility control point Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Microsoft Visual Studio Integration Yes Yes Yes Yes Yes Yes Yes
SQL Server Developer Studio Yes Yes Yes Yes Yes Yes Yes
Intellisense (Transact-SQL and MDX) 1 Yes Yes Yes Yes Yes Yes Yes
SQL Server Data Tools (SSDT) Yes Yes Yes Yes Yes
SQL query edit and design tools1 Yes Yes Yes
Version control support1 Yes Yes Yes
MDX edit, debug, and design tools1 Yes Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Common Language Runtime (CLR) Integration Yes Yes Yes Yes Yes Yes Yes
Native XML support Yes Yes Yes Yes Yes Yes Yes
XML indexing Yes Yes Yes Yes Yes Yes Yes
MERGE & UPSERT Capabilities Yes Yes Yes Yes Yes Yes Yes
FILESTREAM support Yes Yes Yes Yes Yes Yes Yes
FileTable Yes Yes Yes Yes Yes Yes Yes
Date and Time datatypes Yes Yes Yes Yes Yes Yes Yes
Internationalization support Yes Yes Yes Yes Yes Yes Yes
Full-text and semantic search Yes Yes Yes Yes Yes
Specification of language in query Yes Yes Yes Yes Yes
Service Broker (messaging) Yes Yes Yes No (Client only) No (Client only) No (Client only) No (Client only)
Web services (HTTP/SOAP endpoints) Yes Yes Yes Yes
T-SQL endpoints Yes Yes Yes Yes
Feature
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Server Import and Export Wizard Yes Yes Yes Yes Yes Yes Yes
Built-in data source connectors Yes Yes Yes Yes Yes Yes Yes
SSIS designer and runtime Yes Yes Yes
Basic Transforms Yes Yes Yes
Basic data profiling tools Yes Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
High performance Oracle destination Yes
High performance Teradata destination Yes
SAP BW source and destination Yes
Data mining model training destination adapter Yes
Dimension processing destination adapter Yes
Partition processing destination adapter Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Persistent (high performance) lookups Yes
Data mining query transformation Yes
Fuzzy grouping and lookup transformations Yes
Term extractions and lookup transformations Yes
Feature
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Master Data Services database Yes Yes
Master Data Manager web application Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Create cubes without a database Yes Yes Yes
Auto-generate staging and data warehouse schema Yes Yes Yes
Change data capture Yes
Star join query optimizations Yes
Scalable read-only Analysis Services configuration Yes
Proactive caching Yes
Parallel query processing on partitioned tables and indices Yes
Columnstore Indexes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Scalable Shared Databases (Attach/Detach, Read only databases) Yes Yes
High Availability Yes Yes Yes
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) Yes Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Semi-additive Measures Yes Yes
Hierarchies Yes Yes Yes
KPIs Yes Yes Yes
Perspectives Yes Yes
Actions Yes Yes Yes
Account intelligence Yes Yes Yes
Time Intelligence Yes Yes Yes
Custom rollups Yes Yes Yes
Writeback cube Yes Yes Yes
Writeback dimensions Yes Yes
Writeback cells Yes Yes Yes
Drillthrough Yes Yes Yes
Advanced hierarchy types (Parent-Child, Ragged Hiearchies) Yes Yes Yes
Advanced dimensions (Reference dimensions, many-to-many dimensions Yes Yes Yes
Linked measures and dimensions Yes Yes
Translations Yes Yes
Aggregations Yes Yes Yes
Multiple Partitions Yes Yes Yes, up to 3
Proactive caching Yes Yes
Custom Assemblies (stored procs) Yes Yes Yes
MDX queries and scripts Yes Yes Yes
Role-based security model Yes Yes Yes
Dimension and Cell-level Security Yes Yes Yes
Scalable string storage Yes Yes Yes
MOLAP, ROLAP, HOLAP storage modes Yes Yes Yes
Binary and compressed XML transport Yes Yes Yes
Push-mode processing Yes Yes
Direct Writeback Yes Yes
Measure Expressions Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Hierarchies Yes Yes
KPIs Yes Yes
Semi-additive Measures Yes Yes
Perspectives Yes Yes
Translations Yes Yes
DAX calculations, DAX queries, MDX queries Yes Yes
Row-level Security Yes Yes
Partitions Yes Yes
VertiPaq and DirectQuery storage modes (Tabular only) Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SharePoint farm integration based on shared service architecture Yes Yes
Usage reporting Yes Yes
Health monitoring rules Yes Yes
PowerPivot Gallery Yes Yes
PowerPivot Data Refresh Yes Yes
PowerPivot Data Feeds Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Standard Algorithms Yes Yes Yes
Data Mining Tools (Wizards, Editors Query Builders) Yes Yes Yes
Cross Validation Yes Yes
Models on Filtered Subsets of Mining Structure Data Yes Yes
Time Series: Custom Blending Between ARTXP and ARIMA Methods Yes Yes
Time Series: Prediction with New Data Yes Yes
Unlimited Concurrent DM Queries Yes Yes
Advanced Configuration & Tuning Options for Data Mining Algorithms Yes Yes
Support for plug-in algorithms Yes Yes
Parallel Model Processing Yes Yes
Time Series: Cross-Series Prediction Yes Yes
Unlimited attributes for Association Rules Yes Yes
Sequence Prediction Yes Yes
Mult. Predict. Targets for Naïve Bayes, Neural Network and Log. Regr. Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Supported catalog DB SQL Server edition Standard or higher Standard or higher Standard or higher Web Express
Supported data source SQL Server edition All SQL Server editions All SQL Server editions All SQL Server editions Web Express
Report Server Yes Yes Yes Yes Yes
Report Designer Yes Yes Yes Yes Yes
Report Manager Yes Yes Yes Yes Yes
Role based security Yes Yes Yes Yes Yes
Word Export and Rich Text Support Yes Yes Yes Yes Yes
Enhanced gauges and charting Yes Yes Yes Yes Yes
Export to Excel, PDF, and Images Yes Yes Yes Yes Yes
Custom authentication Yes Yes Yes Yes Yes
Report as data feeds Yes Yes Yes Yes Yes
Model support Yes Yes Yes Yes
Create custom roles for role-based security Yes Yes Yes
Model Item security Yes Yes Yes
Infinite click through Yes Yes Yes
Shared component library Yes Yes Yes
Email and file share subscriptions and scheduling Yes Yes Yes
Report history, execution snapshots and caching Yes Yes Yes
SharePoint Integration Yes Yes Yes
Remote and non-SQL data source support1 Yes Yes Yes
Data source, delivery and rendering, RDCE extensibility Yes Yes Yes
Data driven report subscription Yes Yes
Scale out deployment (Web farms) Yes Yes
Alerting2 Yes Yes
Power View2 Yes Yes
For this edition of SQL Server Reporting Services
Use the DB Eng to host the database
Enterprise Std, BI Ent Edit.
Business Intelligence Std, BI Ent Edit.
Standard Std, Ent editions (local or remote)
Web Web edition (local only)
Express with Advanced Services Ex  Advanced Services (local only).
Evaluation Evaluation
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Report Builder Yes Yes Yes
Data Mining Addins for Excel and Visio 2010  Yes Yes Yes
PowerPivot for Excel 2010 Yes Yes
Master Data Services Add-in for Excel Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Spatial indexes Yes Yes Yes Yes Yes Yes Yes
Planar and Geodetic datatypes Yes Yes Yes Yes Yes Yes Yes
Advanced spatial libraries Yes Yes Yes Yes Yes Yes Yes
Import/export of industry-standard spatial data formats Yes Yes Yes Yes Yes Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
SQL Server Migration Assistant Yes Yes Yes Yes Yes Yes Yes
Database mail1 Yes Yes Yes Yes
Feature Name
Enterprise Business Intelligence Standard Web Express with Advanced Services Express with Tools Express
Data Quality Services Yes Yes
StreamInsight StreamInsight Premium Edition StreamInsight Standard Edition StreamInsight Standard Edition StreamInsight Standard Edition
StreamInsight HA StreamInsight Premium Edition


Related posts:

Random Posts

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.

*
*