您现在访问的是微软AZURE全球版技术文档网站,若需要访问由世纪互联运营的MICROSOFT AZURE中国区技术文档网站,请访问 https://docs.azure.cn.

什么是 Azure SQL 数据库服务What is Azure SQL Database service

SQL 数据库是 Microsoft Azure 中通用的关系数据库托管服务,支持关系数据、JSON、空间和 XML 等结构。SQL Database is a general-purpose relational database managed service in Microsoft Azure that supports structures such as relational data, JSON, spatial, and XML. SQL 数据库在以下两个不同的购买模型中实现动态可扩展性能:基于 vCore 的购买模型和基于 DTU 的购买模型。SQL Database delivers dynamically scalable performance within two different purchasing models: a vCore-based purchasing model and a DTU-based purchasing model. SQL 数据库还提供列存储索引(用于极端分析和报告)和内存中 OLTP(用于极端事务处理)等选项。SQL Database also provides options such as columnstore indexes for extreme analytic analysis and reporting, and in-memory OLTP for extreme transactional processing. Microsoft 可无缝处理 SQL 代码库的所有修补和更新,并避开底层基础结构的所有管理。Microsoft handles all patching and updating of the SQL code base seamlessly and abstracts away all management of the underlying infrastructure.

备注

有关 Azure SQL 数据库术语词汇表,请参阅 SQL 数据库术语词汇表For a glossary of terms in Azure SQL Database, see SQL Database terms glossary

Azure SQL 数据库提供下述适用于 Azure SQL 数据库的部署选项:Azure SQL Database provides the following deployment options for an Azure SQL database:

  • 单一数据库,它自己的资源集通过 SQL 数据库服务器进行托管。As a single database with its own set of resources managed via a SQL Database server. 单一数据库类似于 SQL Server 中的包含的数据库A single database is similar to a contained databases in SQL Server.
  • 弹性池,即数据库集合,其中共用资源集通过 SQL 数据库服务器进行托管。An elastic pool, which is a collection of databases with a shared set of resources managed via a SQL Database server. 可以将单一数据库移入或移出弹性池。Single databases can be moved into and out of an elastic pool.
  • 托管实例,即拥有共用资源集的系统数据库和用户数据库的集合。Managed instance, which is a collection of system and user databases with a shared set of resources. 托管实例类似于 Microsoft SQL Server 数据库引擎实例。A managed instance is similar to an instance of the Microsoft SQL Server database engine.

下图显示了这些部署选项:The following illustration shows these deployment options:

部署选项

SQL 数据库与 Microsoft SQL Server 数据库引擎共享其代码库。SQL Database shares its code base with the Microsoft SQL Server database engine. 利用 Microsoft 的云优先策略,首先将 SQL Server 的最新功能发布到 SQL 数据库,然后再发布到 SQL Server 本身。With Microsoft's cloud-first strategy, the newest capabilities of SQL Server are released first to SQL Database, and then to SQL Server itself. 此方法可为你提供 SQL Server 的最新功能,这些新功能已经过数百万个数据库的测试且无任何修补或升级开销。This approach provides you with the newest SQL Server capabilities with no overhead for patching or upgrading - and with these new features tested across millions of databases. 有关公布的新功能信息,请参阅:For information about new capabilities as they are announced, see:

重要

若要了解 SQL 数据库与 SQL Server 的功能差异,以及不同 Azure SQL 数据库部署选项的区别,请参阅 SQL 功能To understand the feature differences between SQL Database and SQL Server, as well as the differences between different Azure SQL Database deployment options, see SQL features.

SQL 数据库通过多个资源类型、服务层和计算大小提供可预测的、动态可缩放的性能,主要表现在:无停机时间、内置智能优化、全局可伸缩性和可用性,以及高级安全选项 - 一切几乎不用人工管理。SQL Database delivers predictable performance with multiple resource types, service tiers, and compute sizes that provides dynamic scalability with no downtime, built-in intelligent optimization, global scalability and availability, and advanced security options — all with near-zero administration. 借助这些功能,用户可将注意力集中在如何快速进行应用开发、加快推向市场,而不需要投入宝贵的时间和资源来管理虚拟机与基础结构。These capabilities allow you to focus on rapid app development and accelerating your time to market, rather than allocating precious time and resources to managing virtual machines and infrastructure. SQL 数据库服务目前在世界各地有 38 个数据中心,且有更多数据中心定期上线,因此你可以在附近的数据中心运行数据库。The SQL Database service is currently in 38 data centers around the world, with more data centers coming online regularly, which enables you to run your database in a data center near you.

可缩放的性能和池Scalable performance and pools

  • 使用单一数据库,每个数据库相互隔离且可移植,每个数据库都有自己有保证的计算、内存和存储资源量。With single databases, each database is isolated from each other and portable, each with its own guaranteed amount of compute, memory, and storage resources. SQL 数据库提供各种满足不同需求的计算、内存和存储资源,并支持纵向和横向动态扩展单一数据库资源SQL Database provides different compute, memory, and storage resources for different needs - and the ability to dynamically scale single database resources up and down. 超大规模服务层单一数据库,您可以扩展到 100 TB,使用快速备份和还原功能。The hyperscale service tier for single database enables you to scale to 100 TB, with fast backup and restore capabilities.
  • 使用弹性池,可以新建数据库,也可以将单一数据库移到资源池中,以最大限度地使用资源和节省资金,并且还能纵向和横向动态扩展弹性池资源With elastic pools, you can create new databases or move single databases into a resource pool to maximize the use of resources and save money - and the ability to dynamically scale elastic pool resources up and down.
  • 使用托管实例,每个托管实例都与其他实例隔离开来,并包含有保证的资源。With managed instances, each managed instance is isolated from other instances with guaranteed resources. 在托管实例中,实例数据库共用资源集,并且能够纵向和横向动态扩展托管实例资源Within a managed instance, the instance databases share a set of resources - and the ability to dynamically scale managed instance resources up and down.

可以在小型单一数据库中生成第一个应用程序,每月的“常规用途”服务层费用很低。然后,可以根据解决方案的需要,随时手动或以编程方式将服务层更改为“业务关键”服务层。You can build your first app on a small, single database at a low cost per month in the general purpose service tier and then change its service tier manually or programmatically at any time to the business critical Service tier to meet the needs of your solution. 可在不给应用或客户造成停机的情况下调整性能。You can adjust performance without downtime to your app or to your customers. 动态可伸缩性可让数据库以透明方式响应快速变化的资源要求,使用户只需为用到的资源付费。Dynamic scalability enables your database to transparently respond to rapidly changing resource requirements and enables you to only pay for the resources that you need when you need them.

动态可伸缩性不同于自动缩放。Dynamic scalability is different from autoscale. 自动缩放是指服务根据条件自动缩放,而动态可伸缩性允许在无停机时间的情况下进行手动缩放。Autoscale is when a service scales automatically based on criteria, whereas dynamic scalability allows for manual scaling without downtime. 单个数据库支持手动动态可伸缩性,但不支持自动缩放。A Single database supports manual dynamic scalability, but not autoscale. 若要获得更多自动体验,请考虑使用弹性池,它允许数据库根据各个数据库需求共享池中的资源。For a more automatic experience, consider using elastic pools, which allow databases to share resources in a pool based on individual database needs. 但是,有一些脚本可帮助自动执行单个数据库的可伸缩性。However, there are scripts that can help automate scalability for a single database. 有关示例,请参阅使用 PowerShell 监视和缩放单个数据库For an example, see Use PowerShell to monitor and scale a single database.

购买模型、服务层级、计算大小和存储量Purchasing models, service tiers, compute sizes, and storage amounts

SQL 数据库提供以下两种购买模型:SQL Database offers two purchasing models:

弹性池可以最大化资源利用率Elastic pools to maximize resource utilization

许多业务和应用程序只要能够创建单一数据库并按需调高或调低性能即可,尤其是当使用模式相对容易预测时。For many businesses and applications, being able to create single databases and dial performance up or down on demand is enough, especially if usage patterns are relatively predictable. 但如果有无法预测的使用模式,则管理成本和业务模式就会变得相当困难。But if you have unpredictable usage patterns, it can make it hard to manage costs and your business model. 弹性池旨在解决此问题。Elastic pools are designed to solve this problem. 概念很简单。The concept is simple. 可以向池而不是单个数据库分配性能资源,并且仅需为池的总体性能资源付费,而无需为单一数据库的性能付费。You allocate performance resources to a pool rather than an individual database and pay for the collective performance resources of the pool rather than for single database performance.

弹性池

使用弹性池时,不需要在资源需求波动时担心如何上下调节数据库性能。With elastic pools, you don’t need to focus on dialing database performance up and down as demand for resources fluctuates. 入池的数据库可根据需要使用弹性池的性能资源。The pooled databases consume the performance resources of the elastic pool as needed. 入池的数据库会使用该池,但不会超出其限制,因此即使单个数据库的使用情况仍不可预测,成本也仍是可预测的。Pooled databases consume but don’t exceed the limits of the pool, so your cost remains predictable even if individual database usage doesn’t. 此外,可以 向池添加和删除数据库,将应用从少量数据库扩展到数千个,而一切费用不会超出由你控制的预算范围。What’s more, you can add and remove databases to the pool, scaling your app from a handful of databases to thousands, all within a budget that you control. 还可以控制池中数据库可用的资源量上限与下限,确保池中不会有任何数据库使用所有的池资源,每个入池数据库的可用资源量都有最低保障。You can also control the minimum and maximum resources available to databases in the pool to ensure that no database in the pool uses all the pool resources and that every pooled database has a guaranteed minimum amount of resources. 若要深入了解如何通过弹性池设计 SaaS 应用程序的模式,请参阅具有 SQL 数据库的多租户 SaaS 应用程序的设计模式To learn more about design patterns for SaaS applications using elastic pools, see Design Patterns for Multi-tenant SaaS Applications with SQL Database.

脚本可以帮助监视和缩放弹性池。Scripts can help with monitoring and scaling elastic pools. 有关示例,请参阅使用 PowerShell 在 Azure SQL 数据库中监视和缩放 SQL 弹性池For an example, see Use PowerShell to monitor and scale a SQL elastic pool in Azure SQL Database

重要

托管实例不支持弹性池。A managed instance does not support elastic pools. 相反,托管实例是共用托管实例资源的实例数据库的集合。Rather, a managed instance is a collection of instance databases that share managed instance resources.

混合使用单一数据库与入池数据库Blend single databases with pooled databases

可将单一数据库与弹性池混合使用,快速轻松地更改单一数据库和弹性池的服务层来适应自己的情况。You can blend single databases with elastic pools and change the service tiers of single databases and elastic pools quickly and easily to adapt to your situation. 凭借 Azure 的功能和作用范围,可将其他 Azure 服务与 SQL 数据库搭配使用以满足独特的应用设计需求,提高成本和资源效益,发掘新的商机。With the power and reach of Azure, you can mix-and-match other Azure services with SQL Database to meet your unique app design needs, drive cost and resource efficiencies, and unlock new business opportunities.

集中监视和警报功能Extensive monitoring and alerting capabilities

内置的性能监视警报工具与性能等级组合使用。You use the built-in performance monitoring and alerting tools, combined with the performance ratings. 使用这些工具,可以根据当前需求或项目性能的需求,快速评估调高或调低性能产生的影响。Using these tools, you can quickly assess the impact of scaling up or down based on your current or project performance needs. 此外,SQL 数据库可发出指标和诊断日志,以便更轻松地监视。Additionally, SQL Database can emit metrics and diagnostic logs for easier monitoring. 可配置 SQL 数据库,将资源使用情况、辅助角色和会话以及连接性存储到以下 Azure 资源之一:You can configure SQL Database to store resource usage, workers and sessions, and connectivity into one of these Azure resources:

  • Azure 存储:用于低价存档大量遥测Azure Storage: For archiving vast amounts of telemetry for a small price

  • Azure 事件中心:用于将 SQL 数据库遥测与自定义监视解决方案或热门管道集成Azure Event Hub: For integrating SQL Database telemetry with your custom monitoring solution or hot pipelines

  • Azure Monitor 日志:用于具有报告、警报和缓解功能的内置监视解决方案。Azure Monitor logs: For built-in monitoring solution with reporting, alerting, and mitigating capabilities.

    体系结构

可用性功能Availability capabilities

在传统的 SQL Server 环境中,通常需要在本地设置(至少)2 台计算机(使用 AlwaysOn 可用性组或故障转移群集实例等功能进行设置),其中包含确切数目的数据副本(以同步方式维护,以便在单个计算机/组件出现故障时提供保护。In a traditional SQL Server environment, you would generally have (at least) 2 machines locally set up with exact (synchronously maintained) copies of the data (using features like AlwaysOn availability groups or Failover Cluster Instances) to protect against a failure of a single machine/component. 这样可以提供高可用性,但在发生损毁数据中心的自然灾难时无法提供保护。This provides high availability but does not protect against a natural disaster destroying your data center.

灾难恢复假设灾难性事件在局部地区发生,而远地部署了另一个包含数据副本的计算机/计算机组。Disaster recovery assumes that a catastrophic event will be geographically localized enough to have another machine/set of machines with a copy of your data far away. 在 SQL Server 中,可以使用以异步模式运行的 Always On 可用性组来获取此功能。In SQL Server, you could use Always On Availability Groups running in async mode to get this capability. 光速问题通常意味着,用户不想要等到远端复制完成后再提交事务,因此,在执行计划外故障转移时可能会丢失数据。The speed of light issues usually means that people do not want to wait for replication to happen that far away before committing a transaction, so there is potential for data loss when you do unplanned failovers.

高级和业务关键服务层级中的数据库的某些功能已经与可用性组的同步功能非常类似Databases in the premium and business critical service tiers already do something very similar to the synchronization of an availability group. 较低服务层级中的数据库使用不同但等效的机制通过存储提供冗余。Databases in lower service tiers provide redundancy through storage using a different but equivalent mechanism. 有相应的逻辑可以防范单个计算机发生故障。There is logic that protects against a single machine failure. 使用活动异地复制功能可以在灾难损毁整个区域时提供保护。The active geo-replication feature gives you the ability to protect against disaster where a whole region is destroyed.

Azure 可用性区域是高可用性问题上的播放。Azure Availability Zones is a play on the high availability problem. 它将尝试以防范构建在单个区域中的单个数据中心服务中断。It tries to protect against the outage of a single data center building within a single region. 因此,它想要防止断电情况或生成的网络。So, it wants to protect against the loss of power or network to a building. 在 SQL Azure,这将使用通过将不同的副本放在不同的可用性区域中 (不同建筑物,有效地),否则像以前一样工作。In SQL Azure, this will work by placing the different replicas in different availability zones (different buildings, effectively) and otherwise working as before.

事实上,Azure 的业界领先的 99.99%可用性服务级别协议(SLA),由 Microsoft 托管数据中心的全球网络提供支持,有助于保持应用全天候运行。In fact, Azure's industry leading 99.99% availability service level agreement (SLA), powered by a global network of Microsoft-managed datacenters, helps keep your app running 24/7. Azure 平台完全管理每个数据库,并保证不会丢失数据并实现高百分比数据可用性。The Azure platform fully manages every database and guarantees no data loss and high percentage of data availability. Azure 会自动处理修补、备份、复制、故障检测;基础的潜在硬件、软件或网络故障;部署 bug 修复、故障转移、数据库升级和其他维护任务。Azure automatically handles patching, backups, replication, failure detection, underlying potential hardware, software or network failures, deploying bug fixes, failovers, database upgrades and other maintenance tasks. 标准可用性是通过将计算层与存储层相隔离来实现的。Standard availability is achieved by a separation of compute and storage layers. 高级可用性的实现方式是将计算和存储层集成到单个节点以提高性能,然后藉此实施类似于 Always On 可用性组的技术。Premium availability is achieved by integrating compute and storage on a single node for performance and then implementing technology similar to Always On Availability Groups under the covers. 有关 Azure SQL 数据库的高可用性功能的完整讨论,请参阅 SQL 数据库可用性For a full discussion of the high availability capabilities of Azure SQL Database, see SQL Database availability. 此外,SQL 数据库还提供内置业务连续性和全局可伸缩性功能,包括:In addition, SQL Database provides built-in business continuity and global scalability features, including:

  • 自动备份Automatic backups:

    SQL 数据库自动执行 Azure SQL 数据库的完整备份、差异备份和事务日志备份,以便能够还原到任何时间点。SQL Database automatically performs full, differential, and transaction log backups of Azure SQL databases to enable you to restore to any point in time. 对于单一数据库和入池数据库,可以将 SQL 数据库配置为,将完整数据库备份存储到 Azure 存储,以供长期备份保留。For single databases and pooled databases, you can configure SQL Database to store full database backups to Azure storage for long-term backup retention. 对于托管实例,还可以执行仅复制备份,以供长期备份保留。For managed instances, you can also perform copy-only backups for long-term backup retention.

  • 时间点还原Point-in-time restores:

    所有 SQL 数据库部署选项都支持恢复到任何 Azure SQL 数据库的自动备份保留期内的任何时间点。All SQL Database deployment options support recovery to any point in time within the automatic backup retention period for any Azure SQL database.

  • 活动异地复制Active geo-replication:

    使用单一数据库和入池数据库,可以在同一或全球分布式 Azure 数据中心内配置至多 4 个可读辅助数据库。Single database and pooled databases allow you to configure up to four readable secondary databases in either the same or globally distributed Azure data centers. 例如,如果有一个 SaaS 应用程序,其中的目录数据库包含大量并发只读事务,请使用活动异地复制来启用全局读取缩放并删除主数据库上因读取工作负荷产生的瓶颈。For example, if you have a SaaS application with a catalog database that has a high volume of concurrent read-only transactions, use active geo-replication to enable global read scale and remove bottlenecks on the primary that are due to read workloads. 对于托管实例,请使用自动故障转移组。For managed instances, use auto-failover groups.

  • 自动故障转移组Auto-failover groups:

    通过所有 SQL 数据库部署选项,可使用故障转移组实现全球范围内的高可用性和负载均衡,包括大量数据库、弹性池和托管实例的透明异地复制和故障转移。All SQL Database deployment options allow you to use failover groups to enable high availability and load balancing at global scale, including transparent geo-replication and failover of large sets of databases, elastic pools, and managed instances. 通过故障转移组,可以最小管理开销创建全球分布式 SaaS 应用程序,将所有复杂监视、路由和故障转移业务流程都留给 SQL 数据库。Failover groups enable the creation of globally distributed SaaS applications with minimal administration overhead leaving all the complex monitoring, routing, and failover orchestration to SQL Database.

  • 区域冗余数据库Zone-redundant databases:

    通过 SQL 数据库,可以跨多个可用性区域预配高级或业务关键数据库或弹性池。SQL Database allows you to provision premium or business critical databases or elastic pools across multiple availability zones. 由于这些数据库和弹性池有多个用于确保高可用性的冗余副本,因此将这些副本置于多个可用性区域可以提高复原能力,包括自动从数据中心规模的故障中恢复而不丢失数据的能力。Because these databases and elastic pools have multiple redundant replicas for high availability, placing these replicas into multiple availability zones provides higher resilience, including the ability to recover automatically from the datacenter scale failures without data loss.

内置智能Built-in intelligence

使用 SQL 数据库,可获得内置智能,帮助你大幅降低运行和管理数据库的成本,并将应用程序的性能和安全性最大化。With SQL Database, you get built-in intelligence that helps you dramatically reduce the costs of running and managing databases and maximizes both performance and security of your application. 通过全天候运行数以百万计的客户工作负荷,SQL 数据库收集和处理大量遥测数据,同时完全尊重幕后客户的隐私。Running millions of customer workloads around-the-clock, SQL Database collects and processes a massive amount of telemetry data, while also fully respecting customer privacy behind the scenes. 各种算法正在不间断计算遥测数据,以便服务可以了解并适应应用程序。Various algorithms are continuously evaluating the telemetry data so that the service can learn and adapt with your application. 基于这一分析,该服务会提出针对特定工作负荷的性能改进建议。Based on this analysis, the service comes up with performance improving recommendations tailored to your specific workload.

自动性能监视和优化Automatic performance monitoring and tuning

SQL 数据库提供针对需要监视的查询的详细见解。SQL Database provides detailed insight into the queries that you need to monitor. SQL 数据库了解数据库模式,使你能够根据工作负荷调整数据库架构。SQL Database's learns about your database patterns and enables you to adapt your database schema to your workload. SQL 数据库提供性能优化建议,可在其中查看并应用优化操作。SQL Database provides performance tuning recommendations, where you can review tuning actions and apply them.

然而,持续监视数据库是一项艰巨且乏味的任务,尤其是在处理多个数据库时。However, constantly monitoring database is a hard and tedious task, especially when dealing with many databases. Intelligent Insights 通过大规模地自动监视 SQL 数据库性能并就性能下降问题发出通知来为你完成此作业,它确定问题的根本原因并在可能的情况下提供性能改进建议。Intelligent Insights does this job for you by automatically monitoring SQL Database performance at scale and it informs you of performance degradation issues, it identifies the root cause of the issue and provides performance improvement recommendations when possible.

可能无法高效管理大量数据库,即使使用 SQL 数据库和 Azure 门户提供的所有可用工具和报表也一样。Managing a huge number of databases might be impossible to do efficiently even with all available tools and reports that SQL Database and Azure portal provide. 可考虑使用自动优化将某些监视和优化操作委派给 SQL 数据库,而不是手动监视和优化数据库。Instead of monitoring and tuning your database manually, you might consider delegating some of the monitoring and tuning actions to SQL Database using automatic tuning. SQL 数据库自动应用建议、测试,并验证每个优化操作,确保性能持续提升。SQL Database automatically apply recommendations, tests, and verifies each of its tuning actions to ensure the performance keeps improving. 这样一来,SQL 数据库将以受控且安全的方式自动适应工作负荷。This way, SQL Database automatically adapts to your workload in controlled and safe way. 自动优化是指在每次优化操作前后仔细监视和比较数据库性能,如果性能未得到提升,则还原优化操作。Automatic tuning means that the performance of your database is carefully monitored and compared before and after every tuning action, and if the performance doesn’t improve, the tuning action is reverted.

目前,在 SQL 数据库上运行 SaaS 多租户应用的许多合作伙伴均依赖于自动性能优化,确保其应用程序始终具有稳定且可预测的性能。Today, many of our partners running SaaS multi-tenant apps on top of SQL Database are relying on automatic performance tuning to make sure their applications always have stable and predictable performance. 对他们而言,此功能可大大降低午夜出现性能事故的风险。For them, this feature tremendously reduces the risk of having a performance incident in the middle of the night. 此外,由于部分客户群也使用 SQL Server,因此他们使用 SQL 数据库提供的相同索引建议来帮助 SQL Sever 客户。In addition, since part of their customer base also uses SQL Server, they are using the same indexing recommendations provided by SQL Database to help their SQL Server customers.

SQL 数据库可从两个方面进行自动优化There are two automatic tuning aspects that are available in SQL Database:

  • 自动索引管理:标识应在数据库中添加的索引以及应删除的索引。Automatic index management: Identifies indexes that should be added in your database, and indexes that should be removed.
  • 自动计划更正:标识有问题的计划并修复 SQL 计划性能问题(即将推出,已在 SQL Server 2017 中提供)。Automatic plan correction: Identifies problematic plans and fixes SQL plan performance problems (coming soon, already available in SQL Server 2017).

自适应查询处理Adaptive query processing

我们还将向 SQL 数据库添加自适应查询处理系列功能,包括交错执行多语句表值函数,批处理模式内存授予反馈和批处理模式自适应联接。We are also adding the adaptive query processing family of features to SQL Database, including interleaved execution for multi-statement table-valued functions, batch mode memory grant feedback, and batch mode adaptive joins. 每个自适应查询处理功能均应用类似的“学习和适应”技巧,帮助进一步解决与历史上棘手的查询优化问题相关的性能问题。Each of these adaptive query processing features applies similar “learn and adapt” techniques, helping further address performance issues related to historically intractable query optimization problems.

高级安全性和符合性Advanced security and compliance

SQL 数据库提供一系列内置安全性和符合性功能,帮助应用程序满足各种安全性和符合性要求。SQL Database provides a range of built-in security and compliance features to help your application meet various security and compliance requirements.

重要

Azure SQL 数据库(所有部署选项)已通过了许多合规性标准的认证。Azure SQL Database (all deployment options), has been certified against a number of compliance standards. 有关详细信息,请参阅Microsoft Azure 信任中心在哪里可以找到 SQL 数据库法规认证的最新列表。For more information, see the Microsoft Azure Trust Center where you can find the most current list of SQL Database compliance certifications.

高级威胁防护Advance Threat Protection

高级数据安全是高级 SQL 安全功能的统一包。Advanced data security is a unified package for advanced SQL security capabilities. 它包括发现敏感数据并分类、管理数据库漏洞以及检测可能对数据库造成威胁的异常活动的功能。It includes functionality for discovering and classifying sensitive data, managing your database vulnerabilities, and detecting anomalous activities that could indicate a threat to your database. 它提供用于启用和管理这些功能的一个转到位置。It provides a single go-to location for enabling and managing these capabilities.

  • 数据发现和分类Data discovery & classification:

    此功能(目前为预览版)提供内置于 Azure SQL 数据库的功能,可用于发现、分类、标记和保护数据库中的敏感数据。This feature (currently in preview) provides capabilities built into Azure SQL Database for discovering, classifying, labeling & protecting the sensitive data in your databases. 它可用于直观查看数据库分类状态,以及跟踪对数据库内和其边界外的敏感数据的访问。It can be used to provide visibility into your database classification state, and to track the access to sensitive data within the database and beyond its borders.

  • 漏洞评估Vulnerability assessment:

    此服务可以发现、跟踪和帮助补救潜在的数据库漏洞。This service can discover, track, and help you remediate potential database vulnerabilities. 它可直观查看安全状态,包括解决安全问题的可操作步骤,并可加强数据库的防御工事。It provides visibility into your security state, and includes actionable steps to resolve security issues, and enhance your database fortifications.

  • 威胁检测Threat detection:

    此功能可检测异常活动,这些活动表示异常和可能有害的数据库访问或使用尝试。This feature detects anomalous activities indicating unusual and potentially harmful attempts to access or exploit your database. 它不断监视数据库的可疑活动,并针对潜在漏洞、SQL 注入攻击和异常数据库访问模式提供即时的安全警报。It continuously monitors your database for suspicious activities, and provides immediate security alerts on potential vulnerabilities, SQL injection attacks, and anomalous database access patterns. 威胁检测警报提供可疑活动的详细信息,并建议如何调查和缓解威胁。Threat detection alerts provide details of the suspicious activity and recommend action on how to investigate and mitigate the threat.

符合性和安全性审核Auditing for compliance and security

审核可跟踪数据库事件,并将事件写入 Azure 存储帐户中的审核日志。Auditing tracks database events and writes them to an audit log in your Azure storage account. 审核可帮助你一直保持符合法规、了解数据库活动,以及深入了解可以指明业务考量因素或疑似安全违规的偏差和异常。Auditing can help you maintain regulatory compliance, understand database activity, and gain insight into discrepancies and anomalies that could indicate business concerns or suspected security violations.

数据加密Data encryption

SQL 数据库可以保护数据。对于动态数据,它使用传输层安全性提供加密;对于静态数据,它使用透明数据加密提供加密;对于使用中的数据,它使用 Always Encrypted 提供加密。SQL Database secures your data by providing encryption for data in motion with transport layer security, for data at rest with transparent data encryption, and for data in use with always encrypted.

Azure Active Directory 集成和多重身份验证Azure Active Directory integration and multi-factor authentication

通过 SQL 数据库,可使用 Azure Active Directory 集成集中管理数据库用户和其他 Microsoft 服务的身份。SQL Database enables you to centrally manage identities of database user and other Microsoft services with Azure Active Directory integration. 此功能简化了权限管理,增强了安全性。This capability simplifies permission management and enhances security. Azure Active Directory 支持多重身份验证 (MFA),以便在支持单一登录过程的同时提高数据和应用程序安全性。Azure Active Directory supports multi-factor authentication (MFA) to increase data and application security while supporting a single sign-in process.

符合性认证Compliance certification

SQL 数据库参与定期审核,并已针对多个符合性标准进行验证。SQL Database participates in regular audits and has been certified against several compliance standards. 有关详细信息,请参阅Microsoft Azure 信任中心在哪里可以找到 SQL 数据库法规认证的最新列表。For more information, see the Microsoft Azure Trust Center where you can find the most current list of SQL Database compliance certifications.

易于使用的工具Easy-to-use tools

SQL 数据库让应用程序的构建和维护更加轻松、高效。SQL Database makes building and maintaining applications easier and more productive. SQL 数据库让你能够专注于自己的专长:生成优秀的应用。SQL Database allows you to focus on what you do best: building great apps. 可使用已有工具和技能在 SQL 数据库进行管理和开发。You can manage and develop in SQL Database using tools and skills you already have.

  • Azure 门户The Azure portal:

    用于管理所有 Azure 服务的基于 Web 的应用程序A web-based application for managing all Azure services

  • SQL Server Management StudioSQL Server Management Studio:

    用于管理任何 SQL 基础结构(从 SQL Server 到 SQL 数据库,不一而足)的免费可下载客户端应用程序。A free, downloadable client application for managing any SQL infrastructure, from SQL Server to SQL Database

  • Visual Studio 中的 SQL Server Data ToolsSQL Server Data Tools in Visual Studio:

    用于开发 SQL Server 关系数据库、Azure SQL 数据库、Integration Services 包、Analysis Services 数据模型和 Reporting Services 报表的免费可下载客户端应用程序。A free, downloadable client application for developing SQL Server relational databases, Azure SQL databases, Integration Services packages, Analysis Services data models, and Reporting Services reports.

  • Visual Studio CodeVisual Studio Code:

    一种可免费下载的开源代码编辑器,适用于 Windows、macOS 和 Linux,并支持各种扩展,其中包括 mssql 扩展(用于查询 Microsoft SQL Server、Azure SQL 数据库和 SQL 数据仓库)。A free, downloadable, open-source, code editor for Windows, macOS, and Linux that supports extensions, including the mssql extension for querying Microsoft SQL Server, Azure SQL Database, and SQL Data Warehouse.

SQL 数据库支持在 MacOS、Linux 和 Windows 上使用 Python、Java、Node.js、PHP、 Ruby 和 .NET 生成应用程序。SQL Database supports building applications with Python, Java, Node.js, PHP, Ruby, and .NET on the MacOS, Linux, and Windows. SQL 数据库和 SQL Server 支持相同的连接库SQL Database supports the same connection libraries as SQL Server.

SQL 数据库常见问题解答 (FAQ)SQL Database frequently asked questions (FAQ)

SQL 数据库的当前版本是多少What is the current version of SQL Database

SQL 数据库的当前版本是 V12。The current version of SQL Database is V12. V11 版本已停用。Version V11 has been retired.

我可以控制修补故障的时间吗Can I control when patching downtime occurs

不。No. 如果在应用中使用重试逻辑,则修补通常不会产生明显影响。The impact of patching is generally not noticeable if you employ retry logic in your app. 有关如何为 Azure SQL 数据库上的计划内维护事件做好准备的详细信息,请参阅规划 Azure SQL 数据库中的 Azure 维护事件For more information about how to prepare for planned maintenance events on your Azure SQL database, see planning for Azure maintenance events in Azure SQL Database.

Azure 混合权益问题Azure Hybrid Benefit questions

面向 SQL Server 的 Azure 混合权益是否具有双倍使用权利Are there dual-use rights with Azure Hybrid Benefit for SQL Server

我们为客户提供 180 天的许可证双倍使用权利,以确保无缝运行迁移。You have 180 days of dual use rights of the license to ensure migrations are running seamlessly. 在 180 天期限过后,SQL Server 许可证只能在云中的 SQL 数据库内使用,并且在本地和云中都没有双倍使用权利。After that 180-day period, the SQL Server license can only be used in the cloud in SQL Database, and does not have dual use rights on-premises and in the cloud.

面向 SQL Server 的 Azure 混合权益与许可证移动性有何区别How does Azure Hybrid Benefit for SQL Server differ from license mobility

目前,我们为 SQL Server 客户提供软件保障许可证移动性权益,以便将其许可证重新分配到第三方共享服务器。Today, we offer license mobility benefits to SQL Server customers with Software Assurance that allows re-assignment of their licenses to third-party shared servers. 可对 Azure IaaS 和 AWS EC2 使用此权益。This benefit can be used on Azure IaaS and AWS EC2. 与许可证移动性相比,面向 SQL Server 的 Azure 混合权益的区别主要体现在两个方面:Azure Hybrid Benefit for SQL Server differs from license mobility in two key areas:

  • 提供经济权益,以便将高度虚拟化的工作负荷转移到 Azure。It provides economic benefits for moving highly virtualized workloads to Azure. 对于高度虚拟化的应用程序,如果 SQL EE 客户在本地拥有一个核心,则他们可以在 Azure 的常规用途 SKU 中获得 4 个核心。SQL EE customers can get 4 cores in Azure in the General Purpose SKU for every core they own on-premises for highly virtualized applications. 许可证移动性不允许使用任何特殊成本权益将虚拟化工作负荷转移到云中。License mobility does not allow any special cost benefits for moving virtualized workloads to the cloud.
  • 它适用于 Azure(SQL 数据库托管实例)上与本地 SQL Server 高度兼容的 PaaS 目标It provides for a PaaS destination on Azure (SQL Database Managed Instance) that is highly compatible with SQL Server on-premises

面向 SQL Server 的 Azure 混合权益的特殊权利有哪些What are the specific rights of the Azure Hybrid Benefit for SQL Server

SQL 数据库客户将获得与面向 SQL Server 的 Azure 混合权益相关的以下权利:SQL Database customers will have the following rights associated with Azure Hybrid Benefit for SQL Server:

许可证足迹License Footprint 面向 SQL Server 的 Azure 混合权益可带来哪些好处?What does Azure Hybrid Benefit for SQL Server Get You?
具有 SA 的 SQL Server Enterprise Edition 核心客户SQL Server Enterprise Edition core customers with SA
  • 可以根据“常规用途”或“业务关键”SKU 支付基准费率Can pay Base Rate on either General Purpose or Business Critical SKU

  • 1 个本地核心 =“常规用途”SKU 中的 4 个核心1 core on-premises = 4 cores in General Purpose SKU

  • 1 个本地核心 =“业务关键”SKU 中的 1 个核心1 core on-premises = 1 core in Business Critical SKU
  • 具有 SA 的 SQL Server Standard Edition 核心客户SQL Server Standard Edition core customers with SA
  • 只能根据“常规用途”SKU 支付基准费率Can pay Base Rate on General Purpose SKU only

  • 1 个本地核心 =“常规用途”SKU 中的 1 个核心1 core on-premises = 1 core in General Purpose SKU
  • 与 SQL Server 工程团队合作Engage with the SQL Server engineering team

    后续步骤Next steps