This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Can DPA take advantage of Query Store?

The native sql query store does provide one key valuable ability to force a particular query plan once captured.

Can or will DPA be able to capture this information and provide recommendations?

  • Clicking on a query takes you to the Query Performance Analyzer page for that query. There is a time series graph on that page showing the different plans for that query and how much time was spent for each. You can then use that information to decide what to do about forcing a particular plan.