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? |
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. |