SQL Server 2014 各版本所支援的功能Features Supported by the Editions of SQL Server 2014

本主題提供不同 SQL Server 2014SQL Server 2014版本所支援功能的詳細資料。This topic provides details of features supported by the different editions of SQL Server 2014SQL Server 2014.

注意︰ [SQL Server]SQL Server中都會提供評估版於 180 天試用期內。NOTE: [SQL Server]SQL Server is available in an Evaluation edition for a 180-day trial period. 如需詳細資訊,請參閱 < [SQL Server]SQL Server 試用軟體網站For more information, see the [SQL Server]SQL Server Trial Software Web Site.

注意: 如 Evaluation 和 Developer edition 所支援的功能,請參閱[SQL Server]SQL ServerEnterprise 功能集。NOTE: For features supported by Evaluation and Developer editions see the [SQL Server]SQL Server Enterprise feature set.

若要導覽至 [SQL Server]SQL Server 技術的資料表,請按一下其連結:To navigate to the table for a [SQL Server]SQL Server technology, click on its link:

跨機箱延展限制Cross-Box Scale Limits

高可用性High Availability

延展性和效能Scalability and Performance

SecuritySecurity

複寫Replication

管理工具Management Tools

RDBMS 管理能力RDBMS Manageability

開發工具Development Tools

可程式性Programmability

Integration ServicesIntegration Services

Integration Services – 進階配接器Integration Services-Advanced Adapters

Integration Services – 進階轉換Integration Services-Advanced Transforms

Master Data ServicesMaster Data Services

資料倉儲Data Warehouse

Analysis Services (英文)Analysis Services

BI 語意模型 (多維度)BI Semantic Model (Multidimensional)

BI 語意模型 (表格式)BI Semantic Model (Tabular)

PowerPivot for SharePointPowerPivot for SharePoint

資料採礦Data Mining

Reporting ServicesReporting Services

商業智慧用戶端Business Intelligence Clients

空間和位置服務Spatial and Location Services

其他資料庫服務Additional Database Services

其他元件Other Components

跨機箱延展限制Cross-Box Scale Limits

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
單一執行個體所使用的最大的計算容量 ([SQL Server]SQL Server Database Engine)1Maximum Compute Capacity Used by a Single Instance ([SQL Server]SQL Server Database Engine)1 作業系統最大值Operating System maximum 限制為 4 個插槽或 16 個核心的較小者Limited to lesser of 4 Sockets or 16 cores 限制為 4 個插槽或 16 個核心的較小者Limited to lesser of 4 Sockets or 16 cores 限制為 4 個插槽或 16 個核心的較小者Limited to lesser of 4 Sockets or 16 cores 限制為 1 個插槽或 4 個核心的較小者Limited to lesser of 1 Socket or 4 cores 限制為 1 個插槽或 4 個核心的較小者Limited to lesser of 1 Socket or 4 cores 限制為 1 個插槽或 4 個核心的較小者Limited to lesser of 1 Socket or 4 cores
單一執行個體 (Analysis Services、 Reporting Services) 所使用的最大的計算容量1Maximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services) 1 作業系統最大值Operating system maximum 作業系統最大值Operating system maximum 限制為 4 個插槽或 16 個核心的較小者Limited to lesser of 4 Sockets or 16 cores 限制為 4 個插槽或 16 個核心的較小者Limited to lesser of 4 Sockets or 16 cores 限制為 1 個插槽或 4 個核心的較小者Limited to lesser of 1 Socket or 4 cores 限制為 1 個插槽或 4 個核心的較小者Limited to lesser of 1 Socket or 4 cores 限制為 1 個插槽或 4 個核心的較小者Limited to lesser of 1 Socket or 4 cores
使用的記憶體上限 ( [SQL Server]SQL Server Database Engine 的每個執行個體)Maximum memory utilized (per instance of [SQL Server]SQL Server Database Engine) 作業系統最大值Operating system maximum 128 GB128 GB 128 GB128 GB 64 GB64 GB 1 GB1 GB 1 GB1 GB 1 GB1 GB
使用的記憶體上限 ( Analysis ServicesAnalysis Services的每個執行個體)Maximum memory utilized (per instance of Analysis ServicesAnalysis Services) 作業系統最大值Operating system maximum 作業系統最大值Operating system maximum 64 GB64 GB N/AN/A N/AN/A N/AN/A N/AN/A
使用的記憶體上限 ( Reporting ServicesReporting Services的每個執行個體)Maximum memory utilized (per instance of Reporting ServicesReporting Services) 作業系統最大值Operating system maximum 作業系統最大值Operating system maximum 64 GB64 GB 64 GB64 GB 4 GB4 GB N/AN/A N/AN/A
關聯式資料庫大小上限Maximum relational Database size 524 PB524 PB 524 PB524 PB 524 PB524 PB 524 PB524 PB 10 GB10 GB 10 GB10 GB 10 GB10 GB

1 Enterprise Edition,含伺服器 + 用戶端存取授權 (CAL) 授權 (不適用於新的協議) 僅限於最多 20 個核心每[SQL Server]SQL Server執行個體。1 Enterprise Edition with Server + Client Access License (CAL) based licensing (not available for new agreements) is limited to a maximum of 20 cores per [SQL Server]SQL Server instance. 核心伺服器授權模式之下沒有任何限制。There are no limits under the Core-based Server Licensing model. 如需詳細資訊,請參閱 Compute Capacity Limits by Edition of SQL ServerFor more information, see Compute Capacity Limits by Edition of SQL Server.

高可用性High Availability

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
Server Core 支援1Server Core support1 Yes Yes Yes Yes Yes Yes Yes
記錄傳送Log Shipping Yes Yes Yes Yes
資料庫鏡像Database mirroring Yes 是 (僅限 Safety Full)Yes (Safety Full Only) 是 (僅限 Safety Full)Yes (Safety Full Only) 僅限見證Witness only 僅限見證Witness only 僅限見證Witness only 僅限見證Witness only
備份壓縮Backup compression Yes Yes Yes
資料庫快照集Database snapshot Yes
AlwaysOn 容錯移轉叢集執行個體Alwayson Failover Cluster Instances 是 (節點支援:作業系統最大值Yes (Node support: Operating system maximum 是 (節點支援:2)Yes (Node support: 2) 是 (節點支援:2)Yes (Node support: 2)
AlwaysOn Availability GroupsAlwaysOn Availability Groups 是 (最多 8 個次要複本,包括 2 個同步次要複本)Yes (up to 8 secondary replicas, including 2 synchronous secondary replicas)
連接導向器Connection Director Yes
線上頁面和檔案還原Online page and file restore Yes
線上檢索索引Online indexing Yes
線上結構描述變更Online schema change Yes
快速復原Fast recovery Yes
鏡像備份Mirrored backups Yes
熱新增記憶體和 CPU2Hot Add Memory and CPU2 Yes
Database Recovery AdvisorDatabase Recovery Advisor Yes Yes Yes Yes Yes Yes Yes
加密的備份Encrypted Backup Yes Yes Yes
智慧型備份Smart Backup Yes Yes Yes No

1如需有關安裝SQL Server 2014SQL Server 2014Server core,請參閱在 Server Core 上安裝 SQL Server 20141For more information on installing SQL Server 2014SQL Server 2014 on Server Core, see Install SQL Server 2014 on Server Core.

2這項功能僅適用於 64 位元[SQL Server]SQL Server2This feature is only available for 64-bit [SQL Server]SQL Server.

延展性和效能Scalability and Performance

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
多個執行個體支援Multi-instance support 5050 5050 5050 5050 5050 5050 5050
資料表和索引分割區Table and index partitioning Yes
資料壓縮Data compression Yes
[資源管理員]Resource Governor Yes
分割區資料表平行處理原則Partition Table Parallelism Yes
多個檔案資料流容器Multiple Filestream containers Yes
NUMA 感知大型分頁記憶體和緩衝區陣列配置NUMA Aware Large Page Memory and Buffer Array Allocation Yes
緩衝集區延伸1Buffer Pool Extension 1 Yes Yes Yes
IO 資源管理IO Resource Governance Yes
記憶體內部 OLTP 1In-Memory OLTP 1 Yes
延遲持久性Delayed durability Yes Yes Yes Yes Yes Yes Yes

1這項功能僅適用於 64 位元[SQL Server]SQL Server1 This feature is only available for 64-bit [SQL Server]SQL Server.

安全性Security

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
基本稽核Basic Auditing Yes Yes Yes Yes Yes Yes Yes
細部稽核Fine Grained Auditing Yes
透明資料庫加密Transparent database encryption Yes
可延伸金鑰管理Extensible Key Management Yes
使用者定義角色User-Defined Roles Yes Yes Yes Yes Yes Yes Yes
自主資料庫Contained Databases Yes Yes Yes Yes Yes Yes Yes
備份的加密Encryption for Backups Yes Yes Yes

ReplicationReplication

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
[SQL Server]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 發行Oracle publishing Yes
點對點異動複寫Peer to Peer transactional replication Yes

Management ToolsManagement Tools

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
SQL 管理物件 (SMO)SQL Management Objects (SMO) Yes Yes Yes Yes Yes Yes Yes
SQL 組態管理員SQL Configuration Manager Yes Yes Yes Yes Yes Yes Yes
SQL CMD (命令提示字元工具)SQL CMD (Command Prompt tool) Yes Yes Yes Yes Yes Yes Yes
[SQL Server]SQL Server Management StudioManagement Studio Yes Yes Yes Yes Yes Yes
Distributed Replay - 管理工具Distributed Replay - Admin Tool Yes Yes Yes Yes Yes Yes
Distributed Replay - ClientDistributed Replay - Client Yes No Yes Yes
Distributed Replay - ControllerDistributed Replay - Controller Yes (Enterprise 最多支援 16 個用戶端,Developer 僅支援 1 個用戶端)Yes (Enterprise supports up to 16 clients, Developer supports only 1 client) No Yes (僅支援 1 個用戶端)Yes (1 client support only) Yes (僅支援 1 個用戶端)Yes (1 client support only)
SQL ProfilerSQL Profiler Yes Yes Yes 2No2 2No2 2No2 2No2
[SQL Server]SQL Server AgentAgent Yes Yes Yes Yes
Microsoft System Center Operations Manager 管理組件Microsoft System Center Operations Manager Management Pack Yes Yes Yes Yes
Database Tuning Advisor (DTA)Database Tuning Advisor (DTA) Yes Yes 3Yes3 3Yes3
[SQL Server]SQL Server 資料庫部署到 Windows Azure VM 精靈Deploy a [SQL Server]SQL Server Database to a Windows Azure VM Wizard Yes Yes Yes Yes Yes Yes Yes
[SQL Server]SQL Server Windows Azure 中的資料檔案Data Files in Windows Azure Yes Yes Yes Yes Yes Yes Yes

2 [SQL Server]SQL Server web SQL Server ExpressSQL Server ExpressSQL Server ExpressSQL Server Express工具,並SQL Server ExpressSQL Server Expresswith Advanced Services 可以使用來分析[SQL Server]SQL Server標準和[SQL Server]SQL ServerEnterprise edition。2 [SQL Server]SQL Server Web, SQL Server ExpressSQL Server Express, SQL Server ExpressSQL Server Express with Tools, and SQL Server ExpressSQL Server Express with Advanced Services can be profiled using [SQL Server]SQL Server Standard and [SQL Server]SQL Server Enterprise editions.

3僅針對 Standard edition 功能啟用微調。3 Tuning enabled only on Standard edition features.

RDBMS ManageabilityRDBMS Manageability

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
使用者執行個體User Instances Yes Yes Yes
LocalDBLocalDB Yes Yes
專用管理員連接Dedicated admin connection Yes Yes Yes Yes 是 (在追蹤旗標下方)Yes (under trace flag) 是 (在追蹤旗標下方)Yes (under trace flag) 是 (在追蹤旗標下方)Yes (under trace flag)
PowerShell 指令碼支援PowerShell scripting support Yes Yes Yes Yes Yes Yes Yes
SysPrep 支援1SysPrep 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
索引檢視表的直接查詢 (使用 NOEXPAND 提示)Direct query of indexed views (using NOEXPAND hint) Yes Yes Yes Yes
自動索引檢視表維護Automatic indexed view maintenance Yes Yes Yes Yes
分散式分割區檢視Distributed partitioned views 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 部分。Partial. 分散式分割區檢視無法更新Distributed Partitioned Views are not updatable 部分。Partial. 分散式分割區檢視無法更新Distributed Partitioned Views are not updatable
平行索引作業Parallel indexed operations Yes
查詢最佳化工具自動使用索引檢視表Automatic use of indexed view by query optimizer Yes
平行一致性檢查Parallel consistency check Yes
[SQL Server]SQL Server 公用程式控制點Utility control point Yes
自主資料庫Contained Databases Yes Yes Yes Yes Yes Yes Yes
緩衝集區延伸2Buffer Pool Extension2 Yes Yes Yes

1 如需詳細資訊,請參閱 使用 SysPrep 安裝 SQL Server 的考量1 For more information, see Considerations for Installing SQL Server Using SysPrep.

2這項功能僅適用於 64 位元[SQL Server]SQL Server2 This feature is only available for 64-bit [SQL Server]SQL Server.

Development ToolsDevelopment Tools

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
MicrosoftMicrosoft Visual Studio 整合Visual Studio Integration Yes Yes Yes Yes Yes Yes Yes
Intellisense (Transact-SQLTransact-SQL 和 MDX)Intellisense (Transact-SQLTransact-SQL and MDX) Yes Yes Yes Yes Yes Yes Yes
SQL Server Data Tools (SSDT)SQL Server Data Tools (SSDT) Yes Yes Yes Yes Yes
SQL 查詢編輯和設計工具1SQL query edit and design tools1 Yes Yes Yes
版本控制支援1Version control support1 Yes Yes Yes
MDX 編輯、 偵錯和設計工具1MDX edit, debug, and design tools1 Yes Yes Yes

1這項功能不適用於 64 位元版本的 Standard edition。1 This feature is not available for 64-bit version of Standard edition.

ProgrammabilityProgrammability

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
Common Language Runtime (CLR) 整合Common Language Runtime (CLR) Integration Yes Yes Yes Yes Yes Yes Yes
原生 XML 支援Native XML support Yes Yes Yes Yes Yes Yes Yes
XML 索引XML indexing Yes Yes Yes Yes Yes Yes Yes
MERGE 與 UPSERT 功能MERGE & UPSERT Capabilities Yes Yes Yes Yes Yes Yes Yes
FILESTREAM 支援FILESTREAM support Yes Yes Yes Yes Yes Yes Yes
FileTableFileTable 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 (訊息)Service Broker (messaging) Yes Yes Yes 否 (僅限用戶端)No (Client only) 否 (僅限用戶端)No (Client only) 否 (僅限用戶端)No (Client only) 否 (僅限用戶端)No (Client only)
Transact-SQLTransact-SQL 端點endpoints Yes Yes Yes Yes

Integration ServicesIntegration Services

功能Feature EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
[SQL Server]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 設計師和執行階段SSIS designer and runtime Yes Yes Yes
基本轉換Basic Transforms Yes Yes Yes
基本資料分析工具Basic data profiling tools Yes Yes Yes
Attunity Oracle 異動資料擷取服務Change Data Capture Service for Oracle by Attunity Yes
Attunity Oracle 異動資料擷取設計工具Change Data Capture Designer for Oracle by Attunity Yes

Integration Services - 進階配接器Integration Services - Advanced Adapters

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
高效能 Oracle 目的地High performance Oracle destination Yes
高效能 Teradata 目的地High performance Teradata destination Yes
SAP BW 來源和目的地SAP BW source and destination Yes
資料採礦模型定型目的地配接器Data mining model training destination adapter Yes
維度處理目的地配接器Dimension processing destination adapter Yes
分割區處理目的地配接器Partition processing destination adapter Yes
Attunity 異動資料擷取元件Change Data Capture components by Attunity Yes
Attunity 開放式資料庫連接 (ODBC) 連接器Connector for Open Database Connectivity (ODBC) by Attunity Yes

Integration Services - 進階轉換Integration Services - Advanced Transforms

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
持續的 (高效能) 查閱Persistent (high performance) lookups Yes
資料採礦查詢轉換Data mining query transformation Yes
模糊群組和查閱轉換Fuzzy grouping and lookup transformations Yes
詞彙擷取與查閱轉換Term extractions and lookup transformations Yes

Master Data ServicesMaster Data Services

注意

  • Master Data ServicesMaster Data Services 只能在 64 位元版本的 Business Intelligence 和 Enterprise 上使用。is available on the 64-bit editions of Business Intelligence and Enterprise only.
功能Feature EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
Master Data ServicesMaster Data Services 資料庫database Yes Yes
主資料管理員Master Data Manager Web 應用程式web application Yes Yes

Data WarehouseData Warehouse

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
建立不含資料庫的 CubeCreate 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
可擴充的唯讀 Analysis Services 組態Scalable read-only Analysis Services configuration Yes
分割區資料表和索引上的查詢平行處理Parallel query processing on partitioned tables and indices Yes
xVelocity 記憶體最佳化的資料行存放區索引xVelocity memory optimized columnstore indexes Yes
全域批次彙總Global Batch Aggregation Yes

Analysis ServicesAnalysis Services

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
可擴充共用資料庫 (附加/卸離唯讀資料庫)Scalable Shared Databases (Attach/Detach, Read only databases) Yes Yes
備份/還原、附加/卸離資料庫Backup/Restore, Attach/Detach databases Yes Yes Yes
同步處理資料庫Synchronize databases Yes Yes
高可用性High Availability Yes Yes Yes
可程式性 (AMO、ADOMD.Net、OLEDB、XML/A、ASSL)Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) Yes Yes Yes

BI 語意模型 (多維度)BI Semantic Model (Multidimensional)

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
局部加總量值Semi-additive Measures Yes Yes 1No1
階層Hierarchies Yes Yes Yes
KPIKPIs 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
回寫 CubeWriteback 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 Yes
AggregationsAggregations Yes Yes Yes
多個分割區Multiple Partitions Yes Yes 是,最多 3 個Yes, up to 3
主動式快取Proactive Caching Yes Yes
自訂組件 (預存程序)Custom Assemblies (stored procs) Yes Yes Yes
MDX 查詢和指令碼MDX queries and scripts Yes Yes Yes
DAX 查詢DAX queries 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 儲存模式MOLAP, ROLAP, HOLAP storage modes Yes Yes Yes
二進位和壓縮 XML 傳輸Binary and compressed XML transport Yes Yes Yes
發送模式處理Push-mode processing Yes Yes
直接回寫Direct Writeback Yes Yes
量值運算式Measure Expressions Yes Yes

1LastChild 局部加總量值在 standard edition 支援,但是其他局部加總量值,例如 None、 FirstChild、 FirstNonEmpty、 LastNonEmpty、 AverageOfChildren 和 ByAccount,不是。1The LastChild semi-additive measure is supported in standard edition, but other semi-additive measures, such as None, FirstChild, FirstNonEmpty, LastNonEmpty, AverageOfChildren, and ByAccount, are not. 所有的版本都支援加總量值 (例如 Sum、Count、Min、Max) 和非加總量值 (DistinctCount)。Additive measures, such as Sum, Count, Min, Max, and non-additive measures (DistinctCount) are supported on all editions.

BI Semantic Model (Tabular)BI Semantic Model (Tabular)

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
階層Hierarchies Yes Yes
KPIKPIs Yes Yes
「檢視方塊」Perspectives Yes Yes
翻譯Translations Yes Yes
DAX 計算、DAX 查詢、MDX 查詢DAX calculations, DAX queries, MDX queries Yes Yes
資料列層級安全性Row-level Security Yes Yes
資料分割Partitions Yes Yes
InMemory 和 DirectQuery 儲存模式 (僅限表格式)In-Memory and DirectQuery storage modes (Tabular only) Yes Yes

PowerPivot for SharePointPowerPivot for SharePoint

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
以共用服務架構為基礎的 SharePoint 伺服器陣列整合SharePoint farm integration based on shared service architecture Yes Yes
使用方式報表Usage reporting Yes Yes
健全狀況監視規則Health monitoring rules Yes Yes
PowerPivot 圖庫PowerPivot Gallery Yes Yes
PowerPivot 資料重新整理PowerPivot Data Refresh Yes Yes
PowerPivot 資料摘要PowerPivot Data Feeds Yes Yes

資料採礦Data Mining

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
標準演算法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
時間序列:ARTXP 和 ARIMA 方法之間的自訂混合Time Series: Custom Blending Between ARTXP and ARIMA Methods Yes Yes
時間序列:使用新資料預測Time Series: Prediction with New Data Yes Yes
無限制的並行 DM 查詢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
貝氏機率、類神經網路和羅吉斯迴歸的多個預測目標Multiple Prediction Targets for Naïve Bayes, Neural Network and Logistic Regression Yes Yes

Reporting ServicesReporting Services

Reporting Services 功能Reporting Services Features

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
支援的目錄 DB [SQL Server]SQL Server 版本Supported catalog DB [SQL Server]SQL Server edition Standard 或更高版本Standard or higher Standard 或更高版本Standard or higher Standard 或更高版本Standard or higher WebWeb ExpressExpress
支援的資料來源 [SQL Server]SQL Server 版本Supported data source [SQL Server]SQL Server edition [SQL Server]SQL Server 所有版本All [SQL Server]SQL Server editions [SQL Server]SQL Server 所有版本All [SQL Server]SQL Server editions [SQL Server]SQL Server 所有版本All [SQL Server]SQL Server editions WebWeb ExpressExpress
報表伺服器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 匯出和 RTF 支援Word Export and Rich Text Support Yes Yes Yes Yes Yes
增強的量測計和圖表Enhanced gauges and charting Yes Yes Yes Yes Yes
匯出至 Excel、PDF 和影像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 整合SharePoint Integration Yes Yes Yes
遠端及非 SQL 資料來源支援1Remote and non-SQL data source support1 Yes Yes Yes
資料來源、傳遞和轉譯、RDCE 擴充性Data source, delivery and rendering, RDCE extensibility Yes Yes Yes
資料驅動報表訂閱Data driven report subscription Yes Yes
向外延展部署 (Web 伺服器陣列)Scale out deployment (Web farms) Yes Yes
警示2Alerting2 Yes Yes
Power ViewPower View 22 Yes Yes

1如需有關支援之資料來源中SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS),請參閱Reporting Services 所支援的資料來源(SSRS)1For more information on the supported datasources in SQL Server 2014 Reporting Services (SSRS)SQL Server 2014 Reporting Services (SSRS), see Data Sources Supported by Reporting Services (SSRS).

2需要Reporting ServicesReporting Services以 SharePoint 模式。2Requires Reporting ServicesReporting Services in SharePoint mode. 如需詳細資訊,請參閱 < Reporting Services SharePoint 模式安裝(SharePoint 2010 和 SharePoint 2013)For more information, see Reporting Services SharePoint Mode Installation (SharePoint 2010 and SharePoint 2013).

報表伺服器資料庫伺服器版本需求Report Server Database Server Edition Requirements

建立報表伺服器資料庫時,並非所有 [SQL Server]SQL Server 版本都可以用來主控資料庫。When creating a report server database, not all editions of [SQL Server]SQL Server can be used to host the database. 下表顯示哪些 Database EngineDatabase Engine 版本可用於特定的 Reporting ServicesReporting Services版本。The following table shows you which editions of the Database EngineDatabase Engine you can use for specific editions of Reporting ServicesReporting Services.

對於這一版的 [SQL Server]SQL Server Reporting ServicesFor this edition of [SQL Server]SQL Server Reporting Services 使用這一版的 Database Engine 執行個體來主控資料庫Use this edition of the Database Engine instance to host the database
EnterpriseEnterprise Standard、Business Intelligence Enterprise 版 (本機或遠端)Standard, Business Intelligence Enterprise, editions (local or remote)
Business IntelligenceBusiness Intelligence Standard、Business Intelligence Enterprise 版 (本機或遠端)Standard, Business Intelligence Enterprise, editions (local or remote)
StandardStandard Standard、Enterprise Edition (本機或遠端)Standard, Enterprise editions (local or remote)
WebWeb Web Edition (僅限本機)Web edition (local only)
Express with Advanced ServicesExpress with Advanced Services Express with Advanced Services (僅限本機)。Express with Advanced Services (local only).
EvaluationEvaluation EvaluationEvaluation

商業智慧用戶端Business Intelligence Clients

您可以透過 Microsoft 下載中心取得下列軟體用戶端應用程式,這些應用程式是提供來協助您建立可在 [SQL Server]SQL Server 執行個體上執行的商業智慧文件。The following software client applications are available on the Microsoft Downloads center and are provided to assist you with creating business intelligence documents that run on a [SQL Server]SQL Server instance. 當您在伺服器環境中裝載這些文件時,請使用支援該文件類型的 [SQL Server]SQL Server 版本。When you host these documents in a server environment, use an edition of [SQL Server]SQL Server that is supported for that document type. 下表將識別哪些 [SQL Server]SQL Server 版本包含裝載在這些用戶端應用程式中建立之文件所需的伺服器功能。The following table identifies which [SQL Server]SQL Server edition contains the server features required to host the documents created in these client applications.

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
報表產生器Report Builder Yes Yes Yes
適用於 Excel 及 Visio 2010 的資料採礦增益集Data Mining Addins for Excel and Visio 2010 Yes Yes Yes
PowerPivot for ExcelPowerPivot for Excel 20102010 Yes Yes
Master Data ServicesMaster Data Services 新增-中適用於 ExcelAdd-in for Excel新增-中適用於 ExcelAdd-in for Excel Yes Yes

注意

  1. PowerPivot for ExcelPowerPivot for Excel 是 Excel 增益集,並不依賴[SQL Server]SQL Serveris an Excel addin and does not depend on [SQL Server]SQL Server. 不過,若要在 SharePoint 中共用 PowerPivot for SharePointPowerPivot for SharePoint 活頁簿並進行共同作業,則需要使用 PowerPivotPowerPivot ,而且這項功能是 [SQL Server]SQL Server Enterprise 和 Business Intelligence Edition 的一部分。However PowerPivot for SharePointPowerPivot for SharePoint is required for sharing and collaborating with PowerPivotPowerPivot workbooks in SharePoint and this capability is available as part of [SQL Server]SQL Server Enterprise and Business Intelligence editions.
  2. 上表識別啟用這些用戶端工具所需的 [SQL Server]SQL Server 版本。不過,這些功能可以存取任何 [SQL Server]SQL Server版本上裝載的資料。The above table identifies the [SQL Server]SQL Server editions that are required to enable these client tools; however these features can access data hosted on any edition of [SQL Server]SQL Server.

Spatial and Location ServicesSpatial and Location Services

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
空間索引Spatial indexes Yes Yes Yes Yes Yes Yes Yes
平面與 Geodetic 資料類型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

Additional Database ServicesAdditional Database Services

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
[SQL Server]SQL Server Migration AssistantMigration Assistant Yes Yes Yes Yes Yes Yes Yes
Database MailDatabase mail Yes Yes Yes Yes

其他元件Other Components

功能名稱Feature Name EnterpriseEnterprise Business IntelligenceBusiness Intelligence StandardStandard WebWeb Express with Advanced ServicesExpress with Advanced Services Express with ToolsExpress with Tools ExpressExpress
Data Quality ServicesData Quality Services Yes Yes
StreamInsightStreamInsight StreamInsight Premium 版StreamInsight Premium Edition StreamInsight Standard 版StreamInsight Standard Edition StreamInsight Standard 版StreamInsight Standard Edition StreamInsight Standard 版StreamInsight Standard Edition
StreamInsight HAStreamInsight HA StreamInsight Premium 版StreamInsight Premium Edition

另請參閱See Also

適用於 SQL Server 2014 的產品規格 Product Specifications for SQL Server 2014
SQL Server 2014 安裝 Installation for SQL Server 2014
SQL Server 2014 快速入門安裝Quick-Start Installation of SQL Server 2014