Redgate Monitor collects estimated and actual query plans and these are parsed to allow Redgate Monitor to provide recommendations using query plan warnings for how you can optimize the query.

These can be accessed from query recommendation summaries by clicking the View recommendations  link. We have initially implemented this on the Query details page in Top queries.

When opened this dialog has two main sections.

• The first contains the query text and buttons to access the query plan and easily copy the SQL.
• The second is the full list of recommendations we have for that query along with a short description of each.

Each recommendation can be further expanded to view the full description with more information and some suggested fixes.