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.

Report

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

Sources

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