SQL Server 2012: Übersicht und Vergleich der Editionen

SQL, Sharepoint und Co > SQL Server > SQL Server 2012 > SQL Server 2012: Übersicht und Vergleich der Editionen

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

Feature NameEnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Max Cap. Single Instance (SQL Server Database Engine)OS maximumMax of 4 Sockets or 16 coresMax of 4 Sockets or 16 coresMax of 4 Sockets or 16 coresMax of 1 Socket or 4 coresMax of 1 Socket or 4 coresMax of 1 Socket or 4 cores
Max Cap. Single Instance (Analysis Services, Reporting Services) OS maximumOS maximumMax of 4 Sockets or 16 coresMax of 4 Sockets or 16 coresMax of 1 Socket or 4 coresMax of 1 Socket or 4 coresMax of 1 Socket or 4 cores
Max Mem (SQL Server Database Engine)OS maximum64 GB64 GB64 GB1 GB1 GB1 GB
Max Mem (Analysis Services)OS maximumOS maximum64 GBN/AN/AN/AN/A
Max Mem (Reporting Services)OS maximumOS maximum64 GB64 GB4 GBN/AN/A
Maximum relational Database size524 PB524 PB524 PB524 PB10 GB10 GB10 GB
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Server Core support1YesYesYesYesYesYesYes
Log ShippingYesYesYesYes
Database mirroringYesYes (Safety Full Only)Yes (Safety Full Only)Witness onlyWitness onlyWitness onlyWitness only
Failover ClusteringYes Nodes OS maximumYes (Node support: 2)Yes (Node support: 2)
Backup compressionYesYesYes
Database snapshotYes
AlwaysOn Availability GroupsYes
SQL Server Multi-Subnet ClusteringYes
Connection DirectorYes
Online page and file restoreYes
Online indexingYes
Online schema changeYes
Fast recoveryYes
Mirrored backupsYes
Hot Add Memory and CPU2Yes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Multi-instance support50505050505050
Table and index partitioningYes
Data compressionYes
Resource GovernorYes
Partition Table ParallelismYes
Multiple Filestream containersYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Basic AuditingYesYesYesYesYesYesYes
Fine Grained AuditingYes
Transparent database encryptionYes
Extensible Key ManagementYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Server change trackingYesYesYesYesYesYesYes
Merge replicationYesYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
Transactional replicationYesYesYesYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
Snapshot replicationYesYesYesYes (Subscriber onlyYes (Subscriber only)Yes (Subscriber only)Yes (Subscriber only)
Heterogeneous subscribersYesYesYes
Oracle publishingYes
Peer to Peer transactional replicationYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Management Objects (SMO)YesYesYes1YesYesYesYes
SQL Configuration ManagerYesYesYesYesYesYesYes
SQL CMD (Command Prompt tool)YesYesYesYesYesYesYes
SQL Server Management StudioYesYesYesYesYesYes
Distributed Replay – Admin ToolYesYesYesYesYesYes
Distributed Replay – ClientYesYesYesYes
Distributed Replay – ControllerYes (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 ProfilerYesYesYesNo2No2No2No2
SQL Server AgentYesYesYesYes
MSCOM Management PackYesYesYesYes
Database Tuning Advisor (DTA)YesYesYes3Yes3
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
User InstancesYesYesYes
Dedicated admin connectionYesYesYesYesYes (under trace flag)Yes (under trace flag)Yes (under trace flag)
PowerShell scripting supportYesYesYesYesYesYesYes
SysPrep support1YesYesYesYesYesYesYes
Support for Data-tier application component operations – extract, deploy, upgrade, deleteYesYesYesYesYesYesYes
Policy automation (check on schedule and change)YesYesYesYes
Performance data collectorYesYesYesYes
Able to enroll as a managed instance in a multi-instance managementYesYesYesYes
Standard performance reportsYesYesYesYes
Plan guides and plan freezing for plan guidesYesYesYesYes
Direct query of indexed views (using NOEXPAND hint)YesYesYesYes
Automatic indexed view maintenanceYesYesYesYes
Distributed partitioned viewsYesDist. part. View No UPDist. part. View No UPDist. part. View No UPDist. part. View No UPDist. part. View No UPDist. part. View No UP
Parallel indexed operationsYes
Automatic use of indexed view by query optimizerYes
Parallel consistency checkYes
SQL Server utility control pointYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Microsoft Visual Studio IntegrationYesYesYesYesYesYesYes
SQL Server Developer StudioYesYesYesYesYesYesYes
Intellisense (Transact-SQL and MDX) 1YesYesYesYesYesYesYes
SQL Server Data Tools (SSDT)YesYesYesYesYes
SQL query edit and design tools1YesYesYes
Version control support1YesYesYes
MDX edit, debug, and design tools1YesYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Common Language Runtime (CLR) IntegrationYesYesYesYesYesYesYes
Native XML supportYesYesYesYesYesYesYes
XML indexingYesYesYesYesYesYesYes
MERGE & UPSERT CapabilitiesYesYesYesYesYesYesYes
FILESTREAM supportYesYesYesYesYesYesYes
FileTableYesYesYesYesYesYesYes
Date and Time datatypesYesYesYesYesYesYesYes
Internationalization supportYesYesYesYesYesYesYes
Full-text and semantic searchYesYesYesYesYes
Specification of language in queryYesYesYesYesYes
Service Broker (messaging)YesYesYesNo (Client only)No (Client only)No (Client only)No (Client only)
Web services (HTTP/SOAP endpoints)YesYesYesYes
T-SQL endpointsYesYesYesYes
Feature
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Server Import and Export WizardYesYesYesYesYesYesYes
Built-in data source connectorsYesYesYesYesYesYesYes
SSIS designer and runtimeYesYesYes
Basic TransformsYesYesYes
Basic data profiling toolsYesYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
High performance Oracle destinationYes
High performance Teradata destinationYes
SAP BW source and destinationYes
Data mining model training destination adapterYes
Dimension processing destination adapterYes
Partition processing destination adapterYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Persistent (high performance) lookupsYes
Data mining query transformationYes
Fuzzy grouping and lookup transformationsYes
Term extractions and lookup transformationsYes
Feature
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Master Data Services databaseYesYes
Master Data Manager web applicationYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Create cubes without a databaseYesYesYes
Auto-generate staging and data warehouse schemaYesYesYes
Change data captureYes
Star join query optimizationsYes
Scalable read-only Analysis Services configurationYes
Proactive cachingYes
Parallel query processing on partitioned tables and indicesYes
Columnstore IndexesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Scalable Shared Databases (Attach/Detach, Read only databases)YesYes
High AvailabilityYesYesYes
Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL)YesYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Semi-additive MeasuresYesYes
HierarchiesYesYesYes
KPIsYesYesYes
PerspectivesYesYes
ActionsYesYesYes
Account intelligenceYesYesYes
Time IntelligenceYesYesYes
Custom rollupsYesYesYes
Writeback cubeYesYesYes
Writeback dimensionsYesYes
Writeback cellsYesYesYes
DrillthroughYesYesYes
Advanced hierarchy types (Parent-Child, Ragged Hiearchies)YesYesYes
Advanced dimensions (Reference dimensions, many-to-many dimensionsYesYesYes
Linked measures and dimensionsYesYes
TranslationsYesYes
AggregationsYesYesYes
Multiple PartitionsYesYesYes, up to 3
Proactive cachingYesYes
Custom Assemblies (stored procs)YesYesYes
MDX queries and scriptsYesYesYes
Role-based security modelYesYesYes
Dimension and Cell-level SecurityYesYesYes
Scalable string storageYesYesYes
MOLAP, ROLAP, HOLAP storage modesYesYesYes
Binary and compressed XML transportYesYesYes
Push-mode processingYesYes
Direct WritebackYesYes
Measure ExpressionsYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
HierarchiesYesYes
KPIsYesYes
Semi-additive MeasuresYesYes
PerspectivesYesYes
TranslationsYesYes
DAX calculations, DAX queries, MDX queriesYesYes
Row-level SecurityYesYes
PartitionsYesYes
VertiPaq and DirectQuery storage modes (Tabular only)YesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SharePoint farm integration based on shared service architectureYesYes
Usage reportingYesYes
Health monitoring rulesYesYes
PowerPivot GalleryYesYes
PowerPivot Data RefreshYesYes
PowerPivot Data FeedsYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Standard AlgorithmsYesYesYes
Data Mining Tools (Wizards, Editors Query Builders)YesYesYes
Cross ValidationYesYes
Models on Filtered Subsets of Mining Structure DataYesYes
Time Series: Custom Blending Between ARTXP and ARIMA MethodsYesYes
Time Series: Prediction with New DataYesYes
Unlimited Concurrent DM QueriesYesYes
Advanced Configuration & Tuning Options for Data Mining AlgorithmsYesYes
Support for plug-in algorithmsYesYes
Parallel Model ProcessingYesYes
Time Series: Cross-Series PredictionYesYes
Unlimited attributes for Association RulesYesYes
Sequence PredictionYesYes
Mult. Predict. Targets for Naïve Bayes, Neural Network and Log. Regr.YesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Supported catalog DB SQL Server editionStandard or higherStandard or higherStandard or higherWebExpress
Supported data source SQL Server editionAll SQL Server editionsAll SQL Server editionsAll SQL Server editionsWebExpress
Report ServerYesYesYesYesYes
Report DesignerYesYesYesYesYes
Report ManagerYesYesYesYesYes
Role based securityYesYesYesYesYes
Word Export and Rich Text SupportYesYesYesYesYes
Enhanced gauges and chartingYesYesYesYesYes
Export to Excel, PDF, and ImagesYesYesYesYesYes
Custom authenticationYesYesYesYesYes
Report as data feedsYesYesYesYesYes
Model supportYesYesYesYes
Create custom roles for role-based securityYesYesYes
Model Item securityYesYesYes
Infinite click throughYesYesYes
Shared component libraryYesYesYes
Email and file share subscriptions and schedulingYesYesYes
Report history, execution snapshots and cachingYesYesYes
SharePoint IntegrationYesYesYes
Remote and non-SQL data source support1YesYesYes
Data source, delivery and rendering, RDCE extensibilityYesYesYes
Data driven report subscriptionYesYes
Scale out deployment (Web farms)YesYes
Alerting2YesYes
Power View2YesYes
For this edition of SQL Server Reporting Services
Use the DB Eng to host the database
EnterpriseStd, BI Ent Edit.
Business IntelligenceStd, BI Ent Edit.
StandardStd, Ent editions (local or remote)
WebWeb edition (local only)
Express with Advanced ServicesEx  Advanced Services (local only).
EvaluationEvaluation
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Report BuilderYesYesYes
Data Mining Addins for Excel and Visio 2010 YesYesYes
PowerPivot for Excel 2010YesYes
Master Data Services Add-in for ExcelYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Spatial indexesYesYesYesYesYesYesYes
Planar and Geodetic datatypesYesYesYesYesYesYesYes
Advanced spatial librariesYesYesYesYesYesYesYes
Import/export of industry-standard spatial data formatsYesYesYesYesYesYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
SQL Server Migration AssistantYesYesYesYesYesYesYes
Database mail1YesYesYesYes
Feature Name
EnterpriseBusiness IntelligenceStandardWebExpress with Advanced ServicesExpress with ToolsExpress
Data Quality ServicesYesYes
StreamInsightStreamInsight Premium EditionStreamInsight Standard EditionStreamInsight Standard EditionStreamInsight Standard Edition
StreamInsight HAStreamInsight Premium Edition


Related posts:

Schreibe einen Kommentar

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