Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
Displays mirroring policy operations statistics for all tables in the database. Mirroring statistics allows you to verify the latency and status of your data export.
Syntax
.show database DatabaseName operations mirroring-statistics
Learn more about syntax conventions.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| DatabaseName | string |
✔️ | The name of the database for which to show the operations mirroring statistics. |
Returns
| Property | Type | Description |
|---|---|---|
| DatabaseName | string |
The name of the database. |
| CompletionPercentage | int |
The status of the mirroring operation as a percentage. |
| PendingDataSize | int |
The size of data in bytes that is pending ingestion or processing. |
| MaxLatency | timespan |
The maximum amount of time in minutes between the last and next time new data was added to your logical copy. |
| NumOfTables | int |
The number of tables in the database. |
Note
When the mirroring policy is enabled, tables can't be renamed.
Example
The following example requests operations mirroring statistics of the Telemetry database.
.show database Telemetry operations mirroring-statistics
Output
| DatabaseName | CompletionPercentage | PendingDataSize | MaxLatency | NumOfTables |
|---|---|---|---|---|
| 4145dac4-ee39-4ec2-aafb-11315b5b7c9b | 100 | 0 | 00:00:00 | 1 |