on 2013 Oct 08 4:52 PM
How are the load_* columns returned by the sa_mirror_server_status system procedure calculated?
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.
Can these values be calculated for non-mirror databases?
Request clarification before answering.
First note that the numbers are for servers not databases.
Here is how the numbers are calculated:
If a server is not involved in any mirrored databases then calling sa_mirror_server_status will not return any useful information since there is no information being computed and accumulated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
9 | |
9 | |
8 | |
6 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.