Azure和Azure SQL数据库以及Azure SQL服务器(托管实例)中本地和SQL VM的比较 [英] Comparison of On-prem and SQL VM in azure and Azure SQL database and Azure SQL server (managed instance)
问题描述
我可以知道以下功能/HA/DR/局限性之间的区别吗?
May I know the difference of function/HA/DR/limitation among the following ?
Azure，Azure SQL数据库和Azure SQL Server(托管实例)中的SQL Server本地和SQL VM
SQL server On-prem and SQL VM in azure and Azure SQL database and Azure SQL server (managed instance)
例如，可以在SQL VM中以天蓝色配置故障转移群集吗?
for example Failover clustering can be configured in SQL VM in azure ?
推荐答案
Hello,
Please read the following resources for comparing all three options.
"> https://docs.microsoft.com/zh-CN/azure/sql-database/sql-database-paas-vs-sql-server-iaas
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-paas-vs-sql-server-iaas
https://blogs.msdn.microsoft.com/azureedu/2016/07/15 /how-should-i-compare-azure-sql-database-paas-to-sql-server-running-on-a-azure-v m-iaas/
使用Azure SQL托管实例，您将具有集群".您可以查询sys.dm_hadr_fabric_nodes DMV来查看托管实例上的所有HADR节点.大小:10pt>
https://blogs.msdn.microsoft.com/azureedu/2016/07/15/how-should-i-compare-azure-sql-database-paas-to-sql-server-running-on-a-azure-vm-iaas/
With you Azure SQL Managed instance you kind of have a "cluster". You can query the sys.dm_hadr_fabric_nodes DMV to see all HADR nodes you have on your Managed Instance.
SELECT * FROM sys.dm_hadr_fabric_nodes
Regards,
Alberto Morillo
SQLCoffee.com
这篇关于Azure和Azure SQL数据库以及Azure SQL服务器(托管实例)中本地和SQL VM的比较的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
