Migration job metrics

Stay organized with collections Save and categorize content based on your preferences.

Database Migration Service collects and displays migration job metrics that represent the health and progress of your data migration process. This page describes the following areas associated with migration job metrics:

• Metrics available on the migration job details page covers the observability information you can view directly in Database Migration Service on the migration job details page.

• Metrics available in Cloud Monitoring describes all metrics related to migration job performance, including the metrics surfaced from the PostgreSQL destination instance.

Metrics available on the migration job details page

The migration job details page shows several diagrams that can help you understand the current state and progress of your migration job. You can filter the information in these diagrams for each database included in your migration job.

Expand the following sections to learn more about each diagram and its associated metric. Database Migration Service migrates a single database for heterogeneous Oracle migrations. Every metric represents data relevant to the database you are migrating.

Throughput

The Throughput diagram uses the migration_job/write_bytes_count metric to represent how much data (in bytes) Database Migration Service has written to your destination database. This metric is sampled every 60 seconds. You can use it to observe the write speed of your migration.

Storage usage in total bytes

The Storage usage in total bytes diagram uses the Cloud SQL database/disk/bytes_used metric to show how much data (in bytes) is stored in the migrated database in your destination Cloud SQL instance. You can use this information to estimate the progress of your migration job.

Replication delay

The Replication delay diagram uses the migration_job/max_replica_sec_lag metric to represent the time difference between the moment when Database Migration Service starts reading Change Data Capture (CDC) information in your source, and the moment when that information is fully replicated in your destination. You can use this information to estimate when to promote the migration job (you want to begin the cutoff process when replication lag is the lowest).

View metrics on the migration job details page

To view metric diagrams on the migration job details page, perform the following steps:

1. In the Google Cloud console, go to the Migration jobs page.

   Go to Migration jobs

2. In the Jobs tab, click the display name of your migration job.

   The migration job details page opens.

3. In the Monitoring section, you can view the Throughput, Storage usage in total bytes, and Replication delay diagrams.

Metrics available in Cloud Monitoring

The following table describes all migration job metrics you can use to create charts in Metrics Explorer for heterogeneous Oracle migrations. The complete metrics Database Migration Service metrics reference lists several additional metrics, but they are not available for heterogeneous Oracle migrations.

You can also use the Cloud SQL cloudsql/database/disk/bytes_used metric and compare it with the total size of your source databases to estimate the migration job progress.