Mirrored database operation logs (Preview)
Mirrored database operation logs are part of the workspace monitoring logs and are registered in the Eventhouse KQL database, which is part of the Real-Time Intelligence solution. You can use these logs to monitor the execution and performance of your mirrored database.
Mirrored database table execution logs
Mirrored database table-level logs provide detailed information about the mirroring execution, complementing the glance view of Mirrored Database monitoring. You can use those logs to:
- Understand the amount of data replicated over time for the mirrored databases/tables.
- Track additions and removals of tables for mirroring.
- Monitor the mirroring status and diagnose failures.
- Measure the time and latency for initial snapshots and incremental data replication.
The following table describes the columns stored in the MirroredDatabaseTableExecution table:
| Column Name | Type | Description |
|---|---|---|
| Timestamp | datetime | The timestamp (UTC) of when the log entry was generated when the record was created by the data source. |
| OperationName | string | The operation associated with the operation log record. Valid values: AddTable, ReplicatingSchema, StartSnapshotting, Snapshotting, StartReplicating, Replicating, StartReseeding, FailTable, RemoveTable, StopTable. |
| ItemId | string | The identifier of the Fabric mirrored database item. |
| ItemKind | string | The type of the Fabric item. Valid values: MirroredDatabase. |
| ItemName | string | The name of the Fabric mirrored database item. |
| WorkspaceId | string | The identifier of the workspace. |
| WorkspaceName | string | The name of the workspace. |
| CapacityId | string | The Fabric capacity identifier hosting the item being operated on. |
| CorrelationId | string | Not applicable. |
| OperationId | string | Not applicable. |
| Identity | string | Not applicable. |
| CustomerTenantId | string | Customer Tenant ID, where the operation was performed. |
| DurationMs | long | Not applicable. |
| Status | string | Not applicable. |
| Level | string | Not applicable. |
| Region | string | The region where the Fabric mirrored database is located. |
| WorkspaceMonitoringTableName | string | The name of the workspace monitoring table. Valid values: MirroredDatabaseTableExecution. |
| OperationStartTime | datetime | The time (UTC) the operation started. |
| OperationEndTime | datetime | The time (UTC) the operation ended. |
| MirroringSourceType | string | The type of the source database, e.g. AzureSqlDatabase, Snowflake. |
| SourceTableName | string | The name of the source table. |
| SourceSchemaName | string | The name of the source schema. |
| ProcessedRows | long | The number of rows processed by the given operation. |
| ProcessedBytes | long | The size of data processed by the given operation. |
| ReplicatorBatchLatency | long | The latency to replicate the batch of data during mirroring. Unit is in seconds. |
| ErrorType | string | The type of the error - UserError or SystemError. |
| ErrorMessage | string | The error message details. |
Sample queries
You can find sample queries in the fabric-samples GitHub repository.