Skip to content

Instantly share code, notes, and snippets.

@MarkPryceMaherMSFT

MarkPryceMaherMSFT/monitorMirroring.kql

Created May 12, 2025 11:36
Show Gist options
  • Save MarkPryceMaherMSFT/4235da96b670f5796702ac58304c88ae to your computer and use it in GitHub Desktop.
Save MarkPryceMaherMSFT/4235da96b670f5796702ac58304c88ae to your computer and use it in GitHub Desktop.
Download ZIP
script that shows when the tables were last replicated
Raw
monitorMirroring.kql
// use when you have workspace monitoring enabled
// when were tables last updated
MirroredDatabaseTableExecutionLogs
| summarize max(Timestamp), sum(ProcessedRows) by SourceSchemaName, SourceTableName
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment