MV_CLUSTER_STATUS

This view stores information about partitions within a cluster.

Learn more about interpreting this view in the Components to Monitor guide.

Column Name	Description
`NODE_ID`	The `ID` of the related node.
`HOST`	The hostname or IP address for the related leaf node.
`PORT`	The port number of the related leaf node.
`DATABASE_NAME`	The name of the related database.
`ROLE`	The role of the related database (orphan, master, child, or reference).
`STATE`	The state of the related database (online, offline, replicating).
`POSITION`	A number indicating the position in the transaction log.
`MASTER_HOST`	The hostname or IP address for the related master aggregator.
`MASTER_PORT`	The port number of the related master aggregator.
`METADATA_MASTER_NODE_ID`	The `ID` of the master aggregator node expected by the metadata.
`METADATA_MASTER_HOST`	The hostname or IP address for the related master aggregator expected by the metadata.
`METADATA_MASTER_PORT`	The port number of the related master aggregator expected by the metadata.
`METADATA_ROLE`	The role of the related database expected by the metadata.
`DETAILS`	An optional message about the current state.
`COMMITTED_POSITION`	The position up to which each transaction has been committed. All pages in the log before this `LSN` are confirmed to be committed.
`HARDENED_POSITION`	The current position in the transaction log on disk. All pages in the log before this `LSN` are written to disk.
`REPLAY_POSITION`	The position up to which changes have been applied to replica. All pages before this `LSN` have been replayed into memory.

Was this article helpful?