Queries With Forced Plans

This report is new in SSMS 17 and, as its name suggests, it shows queries that are executed under an execution plan forced in Query Store. The following shows this report for a database that has one query with a forced execution plan:

Queries With Forced Plans report

The report contains panes similar to the top resource consuming queries report; in the right pane, you can see the execution statistics, while the bottom pane shows the execution plan.

Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.