请输入您要查询的百科知识：

　

词条 Microsoft Azure SQL Database
释义

  1. Popular use cases

  2. Design

  3. Timeline

  4. Pricing

  5. See also

  6. References

{{advert|date=June 2017}}{{technical|date=June 2017}}

Microsoft Azure SQL Database (formerly SQL Azure, SQL Server Data Services, SQL Services, and Windows Azure SQL Database)[1] is a managed cloud database (SaaS) provided as part of Microsoft Azure.

A cloud database is a database that runs on a cloud computing platform, and access to it is provided as a service. Managed database services take care of scalability, backup, and high availability of the database. Azure SQL Database is a managed database service which is different from AWS RDS which is a container service.

Microsoft Azure SQL Database includes built-in intelligence that learns app patterns and adapts to maximize performance, reliability, and data protection.

It was originally announced in 2009 and released in 2010.

Key capabilities include:

  • Continuous learning of your unique app patterns, adaptive performance tuning, and automatic improvements to reliability and data protection[2]
  • Scaling as needed, with virtually no app downtime[3]
  • Management and monitoring of multitenant apps with isolation benefits of one-customer-per-database[4]
  • Leverage open source tools like cheetah,[5] sql-cli,[6] VS Code[7] and Microsoft tools like Visual Studio[8] and SQL Server Management Studio,[9] Azure Management Portal, PowerShell, and REST APIs
  • Data protection[10] with encryption, authentication, limiting user access to the appropriate subset of the data, continuous monitoring and auditing to help detect potential threats and provide a record of critical events in case of a breach

Popular use cases

  • Relational data storage for cloud based applications and web sites
  • Business and consumer web and mobile apps
  • Manage databases for multi-tenant apps (software-as-a-service)
  • Quickly create dev and test databases to speed up development cycles
  • Scale production business services quickly and at a known cost
  • Containerize data in the cloud for isolation and security
  • Outsource database management in order to focus on value-added services

Design

Azure SQL Database shares the SQL Server 2016 codebase. It is compatible with SQL Server 2014 and 2016 and most of the features available in SQL Server 2016 are available in Azure SQL Database. A list of incompatibilities[11] is published by Microsoft.

Timeline

  • 2009 – Service announced[12]
  • 2010 – Service went live[13]
  • 2014 – New version announced[14]
  • 2015 – Elastic Pools announced[15]

Pricing

Azure SQL Database is offered either as a Standalone database or Elastic database pool, and is priced in three tiers: Basic, Standard and Premium. Each tier offers different performance levels to accommodate a variety of workloads.

The resources available for Standalone databases are expressed in terms of Database Transaction Units (DTUs) and for elastic pools in terms of elastic DTUs or eDTUs. A DTU is defined as a blended measure of CPU, memory, and data I/O and transaction log I/O in a ratio determined by an OLTP benchmark workload designed to be typical of real-world OLTP workloads.

Databases are available as Standalone databases or in database pools which allow multiple databases to share storage and compute resources.

Service tierTarget workloads
BasicBest suited for a small database, supporting typically one single active operation at a given time. Examples include databases used for development or testing, or small-scale infrequently used applications.
StandardThe go-to option for most cloud applications, supporting multiple concurrent queries. Examples include workgroup or web applications.
PremiumDesigned for high transactional volume, supporting many concurrent users and requiring the highest level of business continuity capabilities. Examples are databases supporting mission critical applications.

It is also available as a limited service offering with a trial Web site or Mobile service and eligible for use with an Azure trial subscription.

See also

  • Microsoft Azure
  • Oracle Cloud Platform
  • SQL Server
  • Amazon Relational Database Service
  • Relational Database
  • Cloud computing
  • Software as a service

References

1. ^{{cite web|url=https://wheany.com/ms-branding/|title=MS Branding}}
2. ^{{Cite news|url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-learn-and-adapt/|title=Azure SQL Database Learns & Adapts|last=Rabeler|first=Carl|date=October 13, 2016|work=|access-date=2016-11-03|via=}}
3. ^{{Cite web|url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-scale-on-the-fly/|title=Azure SQL Database Scales on the fly|last=Rabeler|first=Carl|date=October 13, 2016|website=|publisher=|access-date=}}
4. ^{{Cite web|url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-build-multi-tenant-apps/|title=Builds Multi-tenant Apps with Azure SQL Database With Isolation and Efficiency|last=Rabeler|first=Carl|date=October 13, 2016|website=|publisher=|access-date=}}
5. ^{{Cite web|url=https://github.com/wunderlist/cheetah|title=wunderlist/cheetah|website=GitHub|access-date=2016-11-03}}
6. ^{{Cite web|url=https://www.npmjs.com/package/sql-cli|title=sql-cli|website=npm|access-date=2016-11-03}}
7. ^{{Cite web|url=https://code.visualstudio.com/|title=Visual Studio Code - Code Editing. Redefined|website=code.visualstudio.com|access-date=2016-11-03}}
8. ^{{Cite web|url=https://www.visualstudio.com/visual-studio-homepage-vs.aspx|title=Any Developer, Any App, Any Platform {{!}} Visual Studio|website=www.visualstudio.com|access-date=2016-11-03}}
9. ^{{Cite web|url=https://msdn.microsoft.com/library/ms174173.aspx|title=Use SQL Server Management Studio|website=msdn.microsoft.com|access-date=2016-11-03}}
10. ^{{Cite web|url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-helps-secures-and-protects/|title=Azure SQL Database Secures and Protects|last=Rabeler|first=Carl|date=September 13, 2016|website=|publisher=|access-date=}}
11. ^{{Cite web|url=https://azure.microsoft.com/en-us/documentation/articles/sql-database-transact-sql-information/|title=Azure SQL Database Transact-SQL differences|last=Byham|first=Rick|date=August 30, 2016|website=|publisher=|access-date=}}
12. ^{{Cite web|url=https://azure.microsoft.com/en-us/blog/sql-data-services-announces-plans-to-accelerate-core-relational-database-features/|title=SQL Data Services announces plans to accelerate core relational database features|website=azure.microsoft.com|access-date=2016-11-03}}
13. ^{{Cite web|url=https://azure.microsoft.com/en-us/blog/sql-azure-the-year-in-review/|title=SQL Azure - The Year in Review|website=azure.microsoft.com|access-date=2016-11-03}}
14. ^{{Cite web|url=https://azure.microsoft.com/en-us/blog/preview-for-greater-sql-server-compatibility-coming-soon-to-azure-sql-database/|title=Preview for greater SQL Server compatibility coming soon to Azure SQL Database|website=azure.microsoft.com|access-date=2016-11-03}}
15. ^{{Cite web|url=https://azure.microsoft.com/en-us/blog/with-newly-available-services-azure-continues-to-be-the-best-place-for-software-as-a-service-developers/|title=Azure continues to be the best place for Software as a Service|website=azure.microsoft.com|access-date=2016-11-03}}
{{Cloud computing}}{{Microsoft}}{{Microsoft Azure Services Platform}}{{Microsoft development tools}}

1 : Microsoft cloud services
随便看

　

开放百科全书收录14589846条英语、德语、日语等多语种百科知识，基本涵盖了大多数领域的百科知识，是一部内容自由、开放的电子版国际百科全书。

　

Copyright © 2023 OENC.NET All Rights Reserved
京ICP备2021023879号 更新时间：2024/11/17 20:11:53