This blog is part of the blog series named SQL Server Monitoring.
Purpose
To show the configured plan guides.
Sources
This feature queries the DMV sys.plan_guides which returns information for existing plan guides.
Report
The report has a table showing each configured plan guide.

Model
The model for the report uses the fact [Plan guides] and the dimension [Database].

Configuration
The feature accept the parameter @Databases and the syntax is the same that is used in the SQL Server Index and Statistics Management solution made by Ola Hallengren.
The default parameter for the feature is “@Databases = ‘USER_DATABASES, msdb'”
Value | Description |
---|---|
SYSTEM_DATABASES | All system databases (master, msdb, model, and tempdb) |
USER_DATABASES | All user databases |
ALL_DATABASES | All databases |
Db1 | The database Db1 |
Db1, Db2 | The databases Db1 and Db2 |
USER_DATABASES, -Db1 | All user databases, except Db1 |
%Db% | All databases that have “Db” in the name |
%Db%, -Db1 | All databases that have “Db” in the name, except Db1 |
ALL_DATABASES, -%Db% | All databases that do not have “Db” in the name |
Scheduling
The default schedule for the feature is every hour (3.600 seconds).
Retention
The default retention for the table dbo.fhsmPlanGuides is 90 days.