sa_mirror_server_status system procedure

Returns the connection status of the current servers and all the servers that are directly or indirectly receiving log pages from the current server. On primary servers, the procedure returns the status of all connected servers.

Syntax

sa_mirror_server_status( )

Result set

Column name	Data type	Description
server_name	CHAR(128)	The name of the server.
state	CHAR(20)	The connection status of the server. It can be one of the following values: connected disconnected
last_updated	TIMESTAMP WITH TIME ZONE	The time the server status was last updated.
load_current	DOUBLE	The amount of work that the database server is currently performing.
load_last_1_min	DOUBLE	The amount of work that the database server has performed in the previous minute.
load_last_5_mins	DOUBLE	The amount of work that the database server has performed in the previous 5 minutes.
load_last_10_mins	DOUBLE	The amount of work that the database server has performed in the previous 10 minutes.
num_connections	UNSIGNED INT	The number of connections to the database server.
num_processors	UNSIGNED INT	The number of database server processors.
log_written	UNSIGNED BIGINT	The latest transaction log position written to disk based on the last update received from the server.
log_applied	UNSIGNED BIGINT	The last operation from the transaction log that has been applied based on the last update received from the server. This value is the same as the value of the CurrentRedoPos property

Remarks

Each server updates its status and that of its copy nodes every 5 seconds. On mirror servers, the procedure returns the status of any copy nodes that are receiving log pages from the mirror server, but does not return the status of the primary server. The columns with the prefix load represent a computed load on the database server. The value returned represents the database server load, and not the load from other processes. Higher load values indicate that the database server has more work to perform.

When the NodeType connection parameter is specified, the database server uses load information to redirect connections. The database server selects the mirror server with the lowest load; if all servers have the same load, the server with the fewest connections is used.

Note

For database servers running in the cloud, the NodeType connection parameter does not use load information to redirect connections.