Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Replication monitor question - 'Log Reader Agent' columns 'Delivery Rate' & 'Latency' meaning

Answered Replication monitor question - 'Log Reader Agent' columns 'Delivery Rate' & 'Latency' meaning

  • Thursday, December 06, 2012 2:55 PM
     
     
    Sign In to Vote
    0

    Hi

    When I look at Replication monitor > Agents tab > Log Reader  Agent 

    There are several columns, I would like to understand the exact meaning

    Delivery Rate : current value is 22   what does it mean ?

    Latency : current value is 2000   what does it mean ?

    thanks in advance

     

    Regards, Asi Pesa

     

All Replies

  • Thursday, December 06, 2012 3:18 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    delivery rate means commands per second - it means the log reader agent is reading that many transactions/commands per second and writing them to the distribution database. The higher numbers the better, but if you have a light workload low values can be acceptable.

    Latency refers to how old a transaction/command is before it is read from the log and written to the distribution database. Low values are good. 2000 seems to indicate 2000 seconds.

    However - where are you seeing these values?

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941

    • Marked As Answer by Asi Pesa Sunday, December 09, 2012 4:21 AM
    •  
     
  • Thursday, December 06, 2012 5:29 PM
     
     
    Sign In to Vote
    0
    Hi

    When I look at Replication monitor > Agents tab > Log Reader  Agent 

    There are several columns, I would like to understand the exact meaning

    Delivery Rate : current value is 22   what does it mean ?

    Latency : current value is 2000   what does it mean ?

    thanks in advance

    Regards, Asi Pesa

     
  • Friday, December 07, 2012 8:01 AM
    Moderator
     
     Answered
    Sign In to Vote
    2

    Hi Asi,

    Delivery rate (cmds/sec): Ratio of delivered commands to the duration of the agent. If the agent is still running, this value reflects a cumulative count from the beginning of the session.
    Latency (msec): The current amount of time, in milliseconds, elapsed from when transactions are applied at the Publisher to when they are delivered to the Distributor.

    For more detail information, please refer to the following link:

    Replication Monitor - Select Columns, Log Reader Agents Tab:
    http://technet.microsoft.com/en-us/library/aa178653(v=sql.80).aspx

    Allen Li
    TechNet Community Support

    • Proposed As Answer by Shahfaisal Muhammed Saturday, December 08, 2012 2:10 PM
    • Marked As Answer by Asi Pesa Sunday, December 09, 2012 4:28 AM
    •  
     
  • Sunday, December 09, 2012 4:36 AM
     
     
    Sign In to Vote
    0

    thank you Hilary.

    I see these values in Replication monitor > Agents tab > Log Reader  Agent .

    Regarding Latency 2000 msec sounds more logical than sec.

    Regards, Asi Pesa