问题描述
我可以知道以下功能/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 ?
推荐答案
请阅读以下资源,以比较所有三个选项.
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
使用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,
阿尔贝托·莫里洛
SQLCoffee.com
Alberto Morillo
SQLCoffee.com
这篇关于Azure和Azure SQL数据库以及Azure SQL服务器(托管实例)中本地和SQL VM的比较的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!