Restoring log - MB/sec

• Krissy

  Ten Centuries

  Points: 1185

  More actions

  February 22, 2006 at 4:21 pm

  #112006

  I am restoring a log backup over a network

  (ie the log file is on ServerA; it is being restored on ServerB)

   

  In the statement:

   

  RESTORE LOG successfully processed 6938 pages in 152.778 seconds (0.372 MB/sec).

   

  What does the (0.372 MB/sec) represent? Is that how fast it going across the network connection?

   

  TIA!

   

   

• Paul Mu

  SSCertifiable

  Points: 5547

  More actions

  February 22, 2006 at 5:21 pm

  #622790

  It appears to be a summary of the time it takes to process the log file during the restore:

  1 page is 8kB in size, so

  6938 pages makes 55.5MB (ie. 6938*8/1000), hence

  55.5/152.778 is 0.363 MB/sec! Not exactly 0.37, but close enough.

• Krissy

  Ten Centuries

  Points: 1185

  More actions

  February 22, 2006 at 5:30 pm

  #622791

  Ahh ok so it doesn't really represent how fast it goes across the network...

   

  Thanks