rs_ticket_history Report

The rs_ticket_history report describes the time that the ticket data took to pass through each Replication Server module from the time stamp reported by the ticket at each module.

The report is generated by the rs_ticket stored procedure. See Replication Server Reference Manual > RSSD Stored Procedures > rs_ticket.

You can calculate the total replication duration from the times reported by a ticket at the primary and replicate databases. In the report, the columns are:

cnt – the ticket sequence number.
pdb_t – the time the rs_ticket stored procedure was executed at the primary database.
rdb_t – the time the ticket arrived at the replicate database.
ticket – information about the ticket, including the time that it passed through each module.

Sample rs_ticket_history Report

cnt       pdb_t                         rdb_t
---       -------------------           -------------------
  1       Jan 19 2010  2:17AM           Jan 19 2010  2:17AM

ticket
-----------------------------------------------------------
V=2;H1=profile1;H2=start;PDB(pdb)=01/19/10 02:17:19.406;
EXEC(40)=01/19/10 02:17:19.423;B(40)=1332;
DIST(26)=01/19/10 02:17:19.669;
DSI(35)=01/19/10 02:17:19.916;
DSI_T=1;DSI_C=3;RRS=SAMPLE_RS_XIEL


cnt       pdb_t                         rdb_t
---       -------------------           -------------------
  2       Jan 19 2010  2:20AM           Jan 19 2010  2:20AM

ticket
-------------------------------------------------------------

V=2;H1=profile1;H2=end;PDB(pdb)=01/19/10 02:20:32.206;
EXEC(40)=01/19/10 02:20:32.211;B(40)=5044893;
DIST(26)=01/19/10 02:20:32.249;DSI(35)=01/19/10 02:20:32.524;
DSI_T=5410;DSI_C=18297;RRS=SAMPLE_RS_XIEL