This blog is part of the blog series named SQL Server Monitoring.
Purpose
To get a status of the execution of FHSQLMonitor tool.
Sources
The FHSQLMonitor internal table dbo.fhsmLog and dbo.fhsmProcessing.
Report
The report has 1 line and stacked column chart that per day shows how the services has executed, and 2 tables where the upper shows all executions regardless of type, and the lower only shows executions logged as warnings or errors.
Processing details – drill-through page
The Processing details page list the individual executions and their duration.
Model
The model for the report uses the fact [Log] and [Processing], and the dimensions [Date], [Time] and [LogTaskName].
