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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.16.79.33