sa_mirror_server_status system procedure

Returns the connection status of servers below the server on which the procedure is executed. 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 information 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. See CurrentRedoPos database property.

Each server updates its status and that of its children to its parent every 5 seconds. The columns with the prefix load represent a computed load on the SQL Anywhere 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.