Hello,
I would like to get a schedule report of query advice on all instances. I'm not seeing this capability. Any know if possible? It's reported on the dashboard, so should be?
Sorry, but there is no capability to do this within the DPA product. However, this information is stored in table in the DPA repository, so custom reports like this: Custom Report - Top Plan Advice may help you manually query the data. This report is in the format of a stored proc you add to the DPA repository database and then can execute it for any monitored instance. Let me know if you have questions.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.