Edit

Monitor digest uploads

  • Article

Applies to: SQL Server 2022 (16.x) Azure SQL Database Azure SQL Managed Instance

You can monitor failed and successful ledger digest uploads in the Azure portal in the Metrics view of your Azure SQL Database.

Metrics view of the Azure SQL Database failed and successful ledger digest uploads in the Azure portal.

You can monitor failed and successful ledger digest uploads with Extended Events in SQL Server. Select the events ledger_digest_upload_failed and ledger_digest_upload_success in the Extended Event session.

You can monitor failed and successful ledger digest uploads with Extended Events in Azure SQL Managed Instance. Select the events ledger_digest_upload_failed and ledger_digest_upload_success in the Extended Event session.

Digest upload alerts recommendation

We recommend you configure alerts on failed ledger digest uploads if you want to be notified when a digest upload failed. Failures might occur due to revoked permissions on the storage account or network configuration that makes the storage account inaccessible. Optionally, you could also configure an alert on successful ledger digest uploads. If the number of successful ledger digest uploads drops under a certain value or zero due to someone disabling the automatic digest upload, the alert can help raise attention to this matter. Digest uploads that are explicitly disabled wouldn't be considered a failure in this case.

We recommend you configure an alert on event number 37417 - Uploading ledger digest failed. The alert can be configured using SQL Agent Alert or your favorite third-party monitoring tool.

We recommend you to use custom SQL Agent jobs to read and process an Extended Event session and alert using Database Mail. Another option is to use a scheduled Azure function, in case Database Mail cannot be used due to any reason.

Related content