SQL Server Monitoring – Monitor configuration

This blog is part of the blog series named SQL Server Monitoring.

Purpose

To get a quick overview of the configuration of the FHSQLMonitor schedules and retentions.

Sources

The FHSQLMonitor internal tables dbo.fhsmSchedules and dbo.fhsmRetentions.

Report

The report has 2 tables where the upper are show the services and their configuration including their last execution time, where the lower show the configured retentions and their last execution time..