SQL Server Monitoring – Ola Hallengren errors

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

Purpose

To provide a wrapper around the SQL Server Index and Statistics Management solution made by Ola Hallengren and show errors detected when executing the solution.

Report

The report has a table listing the errors from the dbo.CommandLog table.

Sources

This feature queries the dbo.CommandLog table where results are stored by the SQL Server Index and Statistics Management solution.

Model

The model for the report uses the facts [Index optimize] and [OH errors], and the dimensions [Date] and [Index].

It is the same model that is used by the Index optimize report.

Configuration

The report uses the same data as used by the Index optimize report.