topic sql-server.databases.backup.age metric in Open Q&A

sql-server.databases.backup.age metric

Sidanat — Tue, 30 Dec 2025 16:13:55 GMT

Can I use the above metric to build a dashboard and alert and if so what would the DQL look like.

Get all databases that are in full recovery mode, filter the transaction log backups only and exclude some database out of the query and send an alert on any database that hasn't had a log backup in the last hour

Re: sql-server.databases.backup.age

AntonPineiro — Tue, 29 Jul 2025 07:28:14 GMT

Hi,

You should be able to do it if that backup metric has recovery mode as dimension.

Best regards

Re: sql-server.databases.backup.age

Sidanat — Tue, 29 Jul 2025 10:04:28 GMT

Thanks for getting back to me is there a way to filter and alert on any database that hasn't had a backup for say 2 hours. Also I don't see a option for differential backups - only full - transactional - full copy-only

Re: sql-server.databases.backup.age

AntonPineiro — Tue, 29 Jul 2025 11:59:16 GMT

Hi,

I would say checking metric "com.dynatrace.extension.sql-oracle.backup.time_since", different dimensions are there to apply filters:

Best regards