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.

Scheduled report of query advice

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.