Wondering how to use table statistics to monitor AWS DMS task? We can help you!
Here at Bobcares, we often handle requests to use table statistics to monitor AWS DMS tasks for our customers using AWS as a part of our Server Management Services.
Today let’s see how our Support Engineers do this for our customers.
How to use Table statistics to monitor AWS DMS task
1. First open the AWS DMS console, and go to Database migration tasks.
2. Then select the name of the task that we wish to monitor.
3. And from the Table statistics section, view column details for the table.
The Load state column has the following states:
Table does not exist: AWS DMS can't find the table on the source endpoint. Before load: The full load process is enabled, but it hasn't started yet. Full load: The full load process is in progress. Table completed: Full load is completed. Table cancelled: Loading of the table is canceled. Table error: An error occurred when loading the table.
The Inserts, Deletes, Updates, and DDLs columns show the number of these statements that were replicated during the change data capture (CDC) phase.
And the Full load rows column shows the total number of rows that were migrated during the full load phase.
Furthermore, the Total column shows the total number of rows that were migrated during the full load and the applied Insert, Update, or Delete statements during the CDC phase.
The Validation state column shows the state of the validation, such as Not enabled, Pending records, Validated, or Error.
The Validation pending, Validation failed, and Validation suspended columns show the number of transactions for each transaction type. For example, this value represents the number of rows that failed validation, are suspended, or are in pending state.
The Last updated column shows the date and time that the information contained in the table statistics tab was last updated.
If we stop and restart a task, the table statistics will get reset.
For example: if we perform a CDC with entries for inserts, updates, and deletes, stopping and resuming a task resets the count to 0.
[Need assistance? We can help you]
To conclude, we saw the steps that our Support Techs follow to use table statistics to monitor AWS DMS task.