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?

asked 08 Oct '13, 15:52

Breck%20Carter's gravatar image

Breck Carter
26.8k420580826
accept rate: 20%


First note that the numbers are for servers not databases.

Here is how the numbers are calculated:

  • each server fires an internal event each second to capture and record the average load on the server during the past second (the load average is computed by the database server kernel - it basically sums up the number of active requests divided by the number of concurrent threads (i.e. cores) being used)
  • every few seconds the stats from each mirror server is sent to the server's parent (in the 'tree' of copy/mirror nodes); an intermediate node passes the data onto its parent, and the primary compiles the stats of all servers.
  • a call to sa_mirror_server_status simply returns the information that has been compiled.

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.

permanent link

answered 08 Oct '13, 16:12

Mark%20Culp's gravatar image

Mark Culp
22.5k9129264
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×239

question asked: 08 Oct '13, 15:52

question was seen: 373 times

last updated: 08 Oct '13, 16:12