Azure SQL Edge 支持的功能Supported features of Azure SQL Edge

Azure SQL Edge 构建在最新版本的 SQL 数据库引擎上。Azure SQL Edge is built on the latest version of the SQL Database Engine. 除了当前在 Linux 上的 SQL Server 2019(或 Windows 上的 SQL Server)中不支持或尚未提供的某些功能外,它还支持 Linux 上的 SQL Server 2019 中支持的一部分功能。It supports a subset of the features supported in SQL Server 2019 on Linux, in addition to some features that are currently not supported or available in SQL Server 2019 on Linux (or in SQL Server on Windows).

有关 Linux 上的 SQL Server 中支持的功能的完整列表,请参阅 Linux 上的 SQL Server 2019 的版本和支持功能For a complete list of the features supported in SQL Server on Linux, see Editions and supported features of SQL Server 2019 on Linux. 有关 Windows 上 SQL Server 的版本和支持的功能,请参阅 SQL Server 2019 (15.x) 的版本和支持的功能For editions and supported features of SQL Server on Windows, see Editions and supported features of SQL Server 2019 (15.x).

Azure SQL Edge 版本Azure SQL Edge editions

Azure SQL Edge 有两个不同的版本或软件计划。Azure SQL Edge is available with two different editions or software plans. 这些版本具有相同的功能集,并且仅在使用权限和它们在主机系统上可以访问的内存量和内核数方面存在差异。These editions have identical feature sets, and only differ in terms of their usage rights and the amount of memory and cores they can access on the host system.

规划Plan 说明Description
Azure SQL Edge 开发人员Azure SQL Edge Developer 仅用于开发。For development only. 每个 Azure SQL Edge 开发人员版容器最多只能有 4 个内核和 32 GB 内存。Each Azure SQL Edge Developer container is limited to up to 4 cores and 32 GB memory.
Azure SQL EdgeAzure SQL Edge 用于生产。For production. 每个 Azure SQL Edge 容器最多只能有 8 个内核和 64 GB 内存。Each Azure SQL Edge container is limited to up to 8 cores and 64 GB memory.

操作系统Operating system

Azure SQL Edge 容器基于 Ubuntu 18.04,因此只能在运行 Ubuntu 18.04 LTS(建议)或 Ubuntu 20.04 LTS 的 Docker 主机上运行。Azure SQL Edge containers are based on Ubuntu 18.04, and as such are only supported to run on Docker hosts running either Ubuntu 18.04 LTS (recommended) or Ubuntu 20.04 LTS. Azure SQL Edge 容器可以在其他操作系统主机上运行,例如,它可以在 Linux 的其他分发版上或 Windows 上运行(使用 Docker CE 或 Docker EE),但 Microsoft 不建议这样做,因为此配置可能没有经过广泛测试。It's possible to run Azure SQL Edge containers on other operating system hosts, for example, it can run on other distributions of Linux or on Windows (using Docker CE or Docker EE), however Microsoft does not recommend that you do this, as this configuration may not be extensively tested.

在 Windows 上运行 Azure SQL Edge 的建议配置是在 Windows 主机上配置 Ubuntu VM,然后在 Linux VM 内运行 Azure SQL Edge。The recommended configuration for running Azure SQL Edge on Windows is to configure an Ubuntu VM on the Windows host, and then run Azure SQL Edge inside the Linux VM.

为 Azure SQL Edge 推荐和支持的文件系统为 EXT4 和 XFS。The recommended and supported file system for Azure SQL Edge is EXT4 and XFS. 如果使用永久性卷来备份 Azure SQL Edge 数据库存储,则基础主机文件系统必须是 EXT4 和 XFS。If persistent volumes are being used to back the Azure SQL Edge database storage, then the underlying host file system needs to be EXT4 and XFS.

硬件支持Hardware support

Azure SQL Edge 需要 64 位处理器(x64 或 ARM64),并且主机上至少有一个处理器和 1 GB RAM。Azure SQL Edge requires a 64-bit processor (either x64 or ARM64), with a minimum of one processor and one GB RAM on the host. 虽然 Azure SQL Edge 的启动内存占用接近 450 MB,但其他在边缘设备上运行的 IoT Edge 模块或进程需要更多内存。While the startup memory footprint of Azure SQL Edge is close to 450MB, the additional memory is needed for other IoT Edge modules or processes running on the edge device. Azure SQL Edge 的实际内存和 CPU 要求取决于工作负荷的复杂性和正在处理的数据量。The actual memory and CPU requirements for Azure SQL Edge will vary based on the complexity of the workload and volume of data being processed. 为解决方案选择硬件时,Microsoft 建议运行广泛的性能测试,以确保满足解决方案所需的性能特征。When choosing a hardware for your solution, Microsoft recommends that you run extensive performance tests to ensure that the required performance characteristics for your solution are met.

Azure SQL Edge 组件Azure SQL Edge components

Azure SQL Edge 仅支持数据库引擎。Azure SQL Edge only supports the database engine. 它不支持 Windows 或 Linux 上的 SQL Server 2019 提供的其他组件。It doesn't include support for other components available with SQL Server 2019 on Windows or with SQL Server 2019 on Linux. 具体而言,Azure SQL Edge 不支持 SQL Server 组件,如 Analysis Services、Reporting Services、Integration Services、Master Data Services、机器学习服务(数据库内)和 Machine Learning Server(独立)。Specifically, Azure SQL Edge doesn't support SQL Server components like Analysis Services, Reporting Services, Integration Services, Master Data Services, Machine Learning Services (In-Database), and Machine Learning Server (standalone).

支持的功能Supported features

除了支持 Linux 上 SQL Server 的一部分功能以外,Azure SQL Edge 还支持以下新功能:In addition to supporting a subset of features of SQL Server on Linux, Azure SQL Edge includes support for the following new features:

  • SQL 流式处理基于支持 Azure 流分析的同一个引擎,用于在 Azure SQL Edge 中提供实时数据流式处理功能。SQL streaming, which is based on the same engine that powers Azure Stream Analytics, provides real-time data streaming capabilities in Azure SQL Edge.
  • 用于时序数据分析的 T-SQL 函数调用 Date_BucketThe T-SQL function call Date_Bucket for Time-Series data analytics.
  • 通过 ONNX 运行时,机器学习功能包含在 SQL 引擎中。Machine learning capabilities through the ONNX runtime, included with the SQL engine.

不支持的功能Unsupported features

以下列表包含 Azure SQL Edge 当前不支持的 Linux 上的 SQL Server 2019 功能。The following list includes the SQL Server 2019 on Linux features that aren't currently supported in Azure SQL Edge.

区域Area 不支持的功能或服务Unsupported feature or service
数据库设计Database Design 内存中 OLTP 以及相关的 DDL 命令、Transact-SQL 函数、目录视图和动态管理视图。In-memory OLTP, and related DDL commands and Transact-SQL functions, catalog views, and dynamic management views.
  HierarchyID 数据类型以及相关的 DDL 命令、Transact-SQL 函数、目录视图和动态管理视图。HierarchyID data type, and related DDL commands and Transact-SQL functions, catalog views, and dynamic management views.
  Spatial 数据类型以及相关的 DDL 命令、Transact-SQL 函数、目录视图和动态管理视图。Spatial data type, and related DDL commands and Transact-SQL functions, catalog views, and dynamic management views.
  Stretch DB 以及相关的 DDL 命令、Transact-SQL 函数、目录视图和动态管理视图。Stretch DB, and related DDL commands and Transact-SQL functions, catalog views, and dynamic management views.
  全文检索和搜索以及相关的 DDL 命令、Transact-SQL 函数、目录视图和动态管理视图。Full-text indexes and search, and related DDL commands and Transact-SQL functions, catalog views, and dynamic management views.
  FileTableFILESTREAM 以及相关的 DDL 命令、Transact-SQL 函数、目录视图和动态管理视图。FileTable, FILESTREAM, and related DDL commands and Transact-SQL functions, catalog views, and dynamic management views.
数据库引擎Database Engine 复制。Replication. 请注意,可以将 Azure SQL Edge 配置为复制拓扑的推送订阅服务器。Note that you can configure Azure SQL Edge as a push subscriber of a replication topology.
  Polybase。Polybase. 请注意,可以将 Azure SQL Edge 配置为 Polybase 中外部表的目标。Note that you can configure Azure SQL Edge as a target for external tables in Polybase.
  通过 Java 和 Spark 实现语言扩展性。Language extensibility through Java and Spark.
  Active Directory 集成。Active Directory integration.
  数据库自动收缩。Database Auto Shrink. 可以使用 ALTER DATABASE <database_name> SET AUTO_SHRINK ON 命令设置数据库的自动收缩属性,但是该更改不起作用。The Auto shrink property for a database can be set using the ALTER DATABASE <database_name> SET AUTO_SHRINK ON command, however that change has no effect. 自动收缩任务不会针对数据库运行。The automatic shrink task will not run against the database. 用户仍可使用“DBCC”命令收缩数据库文件。Users can still shrink the database files using the 'DBCC' commands.
  数据库快照。Database snapshots.
  支持永久性内存。Support for persistent memory.
  Microsoft 分布式事务处理协调器。Microsoft Distributed Transaction Coordinator.
  Resource Governor 和 IO 资源调控。Resource governor and IO resource governance.
  缓冲池扩展。Buffer pool extension.
  具有第三方连接的分布式查询。Distributed query with third-party connections.
  链接服务器。Linked servers.
  系统扩展存储过程(如 XP_CMDSHELL)。System extended stored procedures (such as XP_CMDSHELL).
  CLR 程序集以及相关的 DDL 命令、Transact-SQL 函数、目录视图和动态管理视图。CLR assemblies, and related DDL commands and Transact-SQL functions, catalog views, and dynamic management views.
  CLR 相关的 T-SQL 函数,例如 ASSEMBLYPROPERTYFORMATPARSETRY_PARSECLR-dependent T-SQL functions, such as ASSEMBLYPROPERTY, FORMAT, PARSE, and TRY_PARSE.
  CLR 相关的日期和时间目录视图、函数和查询子句。CLR-dependent date and time catalog views, functions, and query clauses.
  缓冲池扩展。Buffer pool extension.
  数据库邮件。Database mail.
  Service BrokerService Broker
  基于策略的管理Policy Based Management
  管理数据仓库Management Data Warehouse
  包含的数据库Contained Databases
SQL Server 代理SQL Server Agent 子系统:CmdExec、PowerShell、队列读取器、SSIS、SSAS 和 SSRS。Subsystems: CmdExec, PowerShell, Queue Reader, SSIS, SSAS, and SSRS.
  警报。Alerts.
  托管备份。Managed backup.
高可用性High Availability Always On 可用性组。Always On availability groups.
  基本可用性组。Basic availability groups.
  Always On 故障转移群集实例。Always On failover cluster instance.
  数据库镜像。Database mirroring.
  热插拔内存和 CPU。Hot add memory and CPU.
安全性Security 可扩展的密钥管理。Extensible key management.
  Active Directory 集成。Active Directory integration.
  支持安全 Enclave。Support for secure enclaves.
服务Services SQL Server Browser。SQL Server Browser.
  通过 R 和 Python 进行机器学习。Machine Learning through R and Python.
  StreamInsight。StreamInsight.
  Analysis Services。Analysis Services.
  Reporting Services。Reporting Services.
  Data Quality Services。Data Quality Services.
  Master Data Services。Master Data Services.
  Distributed Replay、Distributed Replay.
可管理性Manageability SQL Server 实用工具控制点。SQL Server Utility Control Point.

后续步骤Next steps