SQL Server Monitoring – Stored procedures

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

Purpose

To get a quick overview of the query statistics for stored procedures.

Report

The report has in the upper part a table showing the query statistics for the stored procedures, and in the lower part the same information is shown over time using a stacked column chart.

Sources

This feature queries the DMV sys.dm_exec_procedure_stats.

Model

The model for the report uses the fact [Query statistics stored procedures] and the dimensions [Date], [Time] and [Object].

It is the same model that are used by the Query statistics report.

Configuration

The report uses the same data as used by the Query statistics report.