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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.