Minion Enterprise collects information on AlwaysOn Availability Groups (AGs) into the following tables: 
  • Collector.DMHadrAvailabilityGroupStates
  • Collector.DMHadrAvailabilityReplicaClusterNodes
  • Collector.DMHadrAvailabilityReplicaClusterStates
  • Collector.DMHadrAvailabilityReplicaStates
  • Collector.DMHadrCluster
  • Collector.DMHadrClusterMembers
  • Collector.DMHadrClusterNetworks
  • Collector.DMHadrDatabaseReplicaClusterStates
  • Collector.DMHadrDatabaseReplicaStates
  • Collector.DMHadrInstanceNodeMap
 

Table Detail

This section is under construction.
 
 

Collector.DMHadrAvailabilityGroupStates

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
GroupID uniqueidentifier  
PrimaryReplica sysname  
PrimaryRecoveryHealth tinyint  
PrimaryRecoveryHealthDesc sysname  
SecondaryRecoveryHealth tinyint  
SecondaryRecoveryHealthDesc sysname  
SynchronizationHealth tinyint  
SynchronizationHealthDesc sysname  
 
 
 

Collector.DMHadrAvailabilityReplicaClusterNodes

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
GroupName sysname  
ReplicaServerName sysname  
NodeName sysname  
 
 
 

Collector.DMHadrAvailabilityReplicaClusterStates

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
ReplicaID uniqueidentifier  
ReplicaServerName sysname  
GroupID uniqueidentifier  
JoinState tinyint  
JoinStateDesc sysname  
 
 
 

Collector.DMHadrAvailabilityReplicaStates

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
ReplicaID uniqueidentifier  
GroupID uniqueidentifier  
IsLocal bit  
Role tinyint  
RoleDesc sysname  
OperationalState tinyint  
OperationalStateDesc sysname  
ConnectedState tinyint  
ConnectedStateDesc sysname  
RecoveryHealth tinyint  
RecoveryHealthDesc sysname  
SynchronizationHealth tinyint  
SynchronizationHealthDesc sysname  
LastConnectErrorNumber int  
LastConnectErrorDescription sysname  
LastConnectErrorTimestamp datetime  
 

Collector.DMHadrCluster

Name Type Description
ID bigint Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
cluster_name nvarchar  
quorum_type tinyint  
quorum_type_desc nvarchar  
quorum_state tinyint  
quorum_state_desc nvarchar  
 

Collector.DMHadrClusterMembers

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
MemberName varchar  
MemberType int  
MemberTypeDesc varchar  
MemberState int  
MemberStateDesc varchar  
NumberOfQuorumVotes int  
 
 
 

Collector.DMHadrClusterNetworks

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
MemberName varchar  
NetworkSubnetIP varchar  
NetworkSubnetIPv4Mask varchar  
NetworkSubnetPrefixLength int  
IsPublic int  
IsIPv4 bit  
 
 
 

Collector.DMHadrDatabaseReplicaClusterStates

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
ReplicaID uniqueidentifier  
GroupDatabaseID uniqueidentifier  
DBName sysname Database name.
IsFailoverReady bit  
IsPendingSecondarySuspend bit  
IsDatabaseJoined bit  
RecoveryLSN numeric  
TruncationLSN numeric  
 
 
 

Collector.DMHadrDatabaseReplicaStates

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
DatabaseID int  
GroupID uniqueidentifier  
ReplicaID uniqueidentifier  
GroupDatabaseID uniqueidentifier  
IsLocal bit  
IsPrimaryReplica bit Flag: is the primary replica.
SynchronizationState tinyint  
SynchronizationStateDesc sysname  
IsCommitParticipant bit  
SynchronizationHealth tinyint  
SynchronizationHealthDesc sysname  
DatabaseState tinyint  
DatabaseStateDesc sysname  
IsSuspended bit  
SuspendReason tinyint  
SuspendReasonDesc sysname  
RecoveryLSN numeric  
TruncationLSN numeric  
LastSentLSN numeric  
LastSentTime datetime  
LastReceivedLSN numeric  
LastReceivedTime datetime  
LastHardenedLSN numeric  
LastHardenedTime datetime  
LastRedoneLSN numeric  
LastRedoneTime datetime  
LogSendQueueSize bigint  
LogSendRate bigint  
RedoQueueSize bigint  
RedoRate bigint  
FilestreamSendRate bigint  
EndOfLogLSN numeric  
LastCommitLSN numeric  
LastCommitTime datetime  
LowWaterMarkForGhosts bigint  
 
 
 

Collector.DMHadrInstanceNodeMap

 
Name Type Description
ID int Primary key row identifier.
ExecutionDateTime datetime The execution date and time, common to the run of a collection for a single instance.
InstanceID bigint The instance ID of the instance in question, as defined in the table dbo.Servers. Note: Any time you see InstanceID = 0 in Minion Enterprise, it represents a global default.
AGResourceID sysname  
InstanceName sysname  
NodeName sysname