Home Forums SQL Server 2008 SQL Server 2008 - General Transactional Replication Performance Issues After Migration From 2000 to 2008 RE: Transactional Replication Performance Issues After Migration From 2000 to 2008

  • Distribution Agent Log

    ************************ STATISTICS SINCE AGENT STARTED ***********************

    11-14-2013 13:20:45

    Total Run Time (ms) : 394605 Total Work Time : 389457

    Total Num Trans : 5194 Num Trans/Sec : 13.34

    Total Num Cmds : 8928 Num Cmds/Sec : 22.92

    Total Idle Time : 0

    Writer Thread Stats

    Total Number of Retries : 0

    Time Spent on Exec : 25784

    Time Spent on Commits (ms): 1622 Commits/Sec : 0.13

    Time to Apply Cmds (ms) : 389457 Cmds/Sec : 22.92

    Time Cmd Queue Empty (ms) : 157 Empty Q Waits > 10ms: 10

    Total Time Request Blk(ms): 157

    P2P Work Time (ms) : 0 P2P Cmds Skipped : 0

    Reader Thread Stats

    Calls to Retrieve Cmds : 2

    Time to Retrieve Cmds (ms): 369629 Cmds/Sec : 24.15

    Time Cmd Queue Full (ms) : 19843 Full Q Waits > 10ms : 128