Database Administrators Asked on January 6, 2022
Browsing around some sys tables, I see:
sys.dm_hadr_availability_replica_cluster_nodes.group_name = sys.availability_groups.name
and
sys.dm_hadr_availability_replica_cluster_nodes.replica_server_name = sys.availability_replicas.replica_server_name
and
sys.dm_hadr_availability_replica_cluster_nodes.node_name = sys.availability_replicas.replica_server_name
and
sys.dm_hadr_database_replica_states.group_id = sys.availability_groups.group_id
Could someone please clarify for me whether the “hadr” tables are duplicating data or not? For example, sys.dm_hadr_availability_replica_nodes
and sys.avilability_replicas
sound like they’re describing the same thing.
I guess the question is on how safe it is to join these tables given I can see data values equate – because after all, the same value (something like ‘SQL01’) could conceivably be used to describe different things.
Better yet – is there no entity-relationship diagram published by Microsoft for these sys tables? I can find old posts where people ask the same question about ERDs and there are answers regarding older versions of SQL Server, but all links to diagrams seem outdated and defunct.
It's not duplicating of the information, depending on the requirement we could utilize anyone them:
sys.dm_
represents DMV the under lying information from Dynamic Management viewssys.
represents catalog views. For more details..Answered by Shekar Kola on January 6, 2022
1 Asked on December 19, 2020 by revolucion-for-monica
1 Asked on December 19, 2020 by aditya-bhardwaj
1 Asked on December 19, 2020
availability groups distributed availability groups sql server
4 Asked on December 16, 2020 by ronaldo
1 Asked on December 16, 2020 by j-hache
1 Asked on December 16, 2020 by gagandeep-singh
1 Asked on December 15, 2020
1 Asked on December 14, 2020 by adam-mulla
0 Asked on December 12, 2020
1 Asked on December 12, 2020 by michelle
3 Asked on December 11, 2020 by rai-micheal
1 Asked on December 10, 2020 by mihir-rane
0 Asked on December 8, 2020 by mouchin777
1 Asked on December 7, 2020 by chad-richardson
0 Asked on December 7, 2020 by nalzok
3 Asked on December 7, 2020 by genichm
1 Asked on December 7, 2020 by misterghost
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir