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.
Syntaxsa_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:
In some circumstances, a disconnected server has a status of connected. When this situation occurs, the last_updated time is in the past. |
| 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 INTEGER | The number of connections to the database server. |
| num_processors | UNSIGNED INTEGER | 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 |
RemarksEach 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.
The time in the last_updated column is that of the server in the server_name column. The state is accurate for the time returned in the last_updated column.
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.
For database servers running in the cloud, the NodeType connection parameter does not use load information to redirect connections.
If a copy node was shut down at approximately the same time as its parent, the procedure may still report that the copy node is connected for several minutes. However, the last_updated column remains the same, indicating that the copy node has not reported updated status messages and is likely disconnected.
PrivilegesNone
Side effectsNone
See also Example |
Discuter à propos de cette page dans DocCommentXchange.
|
Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0 |