Page History
...
PW_SYWC_WAIT_COUNTERS_T
Contains wait counter 's data.
| Column Name | Column Name |
|---|---|
SYWC_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYWC_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and |
SYWC_PWHG_ID | Hour group ID. |
SYWC_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYWC_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYWC_WAIT_TYPE | Wait type ID. |
SYWC_WAITING_TASKS_COUNT_SUM | Wait event's counter. |
SYWC_TOTAL_WAIT_TIME_SUM | Summarized wait event's total wait time. |
PW_SYWG_WAIT_GROUPS_T
Contains wait counter data group by wait groups.
| Column Name | Column Name |
|---|---|
SYWG_PWII_INSTANCE_ID | ID of the Sybase instance. |
SYWG_TIMESTAMP | Date and time the statistic was sampled. On an hourly summary level, the date and time are GMT. On all other summary levels, the time is zeroed and |
SYWG_PWHG_ID | Hour group ID. |
SYWG_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYWG_RECEIVED_TIMESTAMP | Local date and time the row was loaded into the PMDB. |
SYWG_WAIT_GROUP | Wait group ID. |
SYWG_WAITING_TASKS_COUNT_SUM | Wait event's counter. |
SYWG_TOTAL_WAIT_TIME_SUM | Summarized wait event's total wait time. |
PW_SYRA_REP_AGENT_STATS_T
| Column Name | Column Name |
|---|---|
SYRA_PWII_INSTANCE_ID | Adaptive Server Enterprise instance name. |
SYRA_REP_SERVER_ID | Replication server name. |
SYRA_DATABASE_ID | Database name. |
SYRA_TIMESTAMP | Timestamp. |
SYRA_PWHG_ID | Hour group ID. |
SYRA_MINUTES_COUNT_SUM | The timeframe needed to calculated the row (in minutes). |
SYRA_RECEIVED_TIMESTAMP | Received timestamp. |
SYRA_SUM_IO_WAIT_SUM | Time that the RepAgent waited for the replication server to parse the LTL, normalize the LTL according to the replication definitions, pack the LTL into a binary format, and then send to the SQM. |
SYRA_TRUNCPT_MOVED_SUM | Number of times the RepAgent asked the replication server for a new secondary truncation point and moved the secondary truncation point in the log. |
SYRA_TRUNCPT_GOTTEN_SUM | Number of times the RepAgent asked the replication server for a new secondary truncation point and got it. |
SYRA_PACKETS_SENT_SUM | Total number of packets sent. |
SYRA_FULL_PACKETS_SENT_SUM | Number of packets that were sent full. |
SYRA_LOG_RECORDS_SCANNED_SUM | Number of log records scanned. |
SYRA_LOG_RECORDS_PROCESSED_SUM | Number of log records scanned, converted to LTL, and then sent to the replication server. |
SYRA_XCMDTEXT_PROCESSED_SUM | Number of DML commands read from the log. |
SYRA_XWRTEXT_PROCESSED_SUM | Number of writetext operations that are being replicated. |
SYRA_XROWIMAGE_PROCESSED_SUM | Number of row images that are processed. |
SYRA_ROWID | Row ID. |