rs_ticket_history

Stores rs_ticket information.

Column

Datatype

Description

cnt

int identity

Ticket unique sequence.

h1

varchar(10)

Ticket header. Set as “-” if a header is not present.

h2

varchar(10)

Ticket header. Set as “-” if a header is not present.

h3

varchar(10)

Ticket header. Set as “-” if a header is not present.

h4

varchar(50)

Ticket header. Set as “-” if a header is not present.

pdb

varchar(30)

Primary database name.

prs

varchar(30)

Primary Replication Server name. Set to “-” if no primary Replication Server is specified.

rrs

varchar(30)

Replicate Replication Server name.

rdb

varchar(30)

Replicate database name.

pdb_t

datetime

The time the rs_ticket stored procedure was executed at the primary database.

exec_t

datetime

The time the ticket passed through the Replication Server executor thread.

dist_t

datetime

The time the ticket passed through the DIST thread.

rsi_t

datetime

The time the ticket passed through the RSI thread.

dsi_t

datetime

The time the ticket passed through the DSI thread.

rdb_t

datetime

The time the ticket arrived at the replicate database.

exec_b

int

Total bytes received by the EXEC thread.

rsi_b

int

Total bytes received by the RSI thread.

dsi_tnx

int

Total number of transactions observed by DSI.

dsi_cmd

int

Total number of commands observed by DSI.

ticket

varchar(1024)

Raw ticket.

Indexes

Unique clustered index rs_ticket_idx on rs_ticket_history(cnt)